[Qgis-user] DB Manager errors loadin shapefile to PostGIS

[G. Allegri]

I'm obtaining the following errors when I try to load (drag&drop) a
shapefile do PostGIS.

I'm running PostGIS 1.5 on Postgresql 9.1.

QGis 1.9 on Windows 7 64bit.


The first error (ERROR1) I've supposed was an encoding issue and float
overflow due to the coordinate fields in the DBF.

The DB encoding is UTF-8.

The error happens whichever encoding I choose.


------------------------------------------------

ERROR1

------------------------------------------------

Error 7

Feature write errors:

Creation error for features from #0 to #0. Provider errors was:

PostGIS error while adding features: ERROR: numeric field overflow

DETAIL: A field with precision 19, scale 11 must round to an absolute value
less than 10^8.

Only 0 of 20 features written

------------------------------------------------



I've opened the DBF with LibOffice to change encoding and format cells to
lesser decimals.

Now I get ERROR2. Considera that I don't have any reg2011 table on the DB
when this happens.


------------------------------------------------

ERROR2

------------------------------------------------

Error 7

Feature write errors:

Creation error for features from #0 to #0. Provider errors was:

PostGIS error while adding features: ERROR: new row for relation "reg2011"
violates check constraint "enforce_geotype_geom"

Only 0 of 20 features written.

------------------------------------------------


The link to the original test shapefile is [1]


giovanni



[1] http://www.istat.it/it/files/2011/04/reg2011.zip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120823/2a827d83/attachment.html>