[gdal-dev] PostgreSQL

[Even Rouault]

Le jeudi 22 septembre 2011 17:48:29, Andy Colson a écrit :
> Hi List,
> 
> I'm using ogr2ogr to convert (and reproject) data from shapefile to PG,
> if I use insert statements the null dates are not a problem, but if I
> set PG_USE_COPY=YES, then I get errors:
> 
> ERROR 1: COPY statement failed.
> ERROR:  date/time field value out of range: "0000/00/00"
> CONTEXT:  COPY parcelannov2, line 18, column recorded: "0000/00/00"
> 
> Inserts are really slow, so I'd love to use copy instead.

I didn't manage to get 0000/00/00 from a shapefile. I have done a few tests but 
I got null values as expected and they are correctly written as null values in 
the PG COPY statement. Perhaps you should file a Trac ticket with the shapefile 
attached and your exact ogr2ogr command line.

> 
> On another layer, regardless of insert/copy, I'm getting:
> 
> ERROR:  numeric field overflow
> DETAIL:  A field with precision 19, scale 11 must round to an absolute
> value less than 10^8.
> CONTEXT:  COPY poltwppoly, line 1, column shape_area:
> "1005965403.24000000954"

adding -lco PRECISION=NO might perhaps help

> 
> I'm using: GDAL 1.9dev, released 2011/01/18
> 
> I can make the shapefiles available if it would be of help.  Is there
> anything else I can do/try/offer?
> 
> Thanks,
> 
> -Andy
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev