Feature request #13933

Improve help file of "Import vector into POSTGIS" - error when fields have high precision values

Added by Filipe Dias almost 2 years ago. Updated 6 months ago.

Status:Open
Priority:Normal
Assignee:Giovanni Manghi
Category:Processing/GDAL
Pull Request or Patch supplied:No Resolution:
Easy fix?:No

Description

I was trying to import a vector into Postgis using "Import vector into POSTGIS (available connections and new connection)" (OGR Miscellaneous) and got these kinds of errors which, I think, are caused by one of the fields having high precision.

ERROR 1: COPY statement failed.

ERROR:  numeric field overflow
DETAIL:  A field with precision 19, scale 15 must round to an absolute value less than 10^4.
CONTEXT:  COPY teste1, line 58, column perimeter: "15814.399999999999636"

If I uncheck "Keep width and precision of input attributes" it works.

I would suggest add a note on this to the help file

History

#1 Updated by Giovanni Manghi 6 months ago

  • Easy fix? set to No

Also available in: Atom PDF