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

[G. Allegri]

I've just tried to load the corrected version (ERROR2) with shp2pgsql and
it works fine.

giovanni

2012/8/23 G. Allegri <giohappy at gmail.com>

> 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/9358b463/attachment.html>