I've just tried to load the corrected version (ERROR2) with shp2pgsql and it works fine.
giovanni 2012/8/23 G. Allegri <[email protected]> > 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 > >
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
