[gdal-dev] PostgreSQL
Even Rouault
even.rouault at mines-paris.org
Wed Sep 28 15:28:26 EDT 2011
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
More information about the gdal-dev
mailing list