On 9/29/2011 1:36 AM, Even Rouault wrote:
Le mercredi 28 septembre 2011 21:28:26, Even Rouault a écrit :
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 inspection, the null values for Date in this dbf file were indicated by a
string filled with spaces. The fix is now in the shapefile driver in r23127.
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
Really? Weird. I have a little program you can write sql and hit .dbf
files, I can run:
select count(*) from ParcelAnnoV2 where recorded is null
and it returns 34490 rows. But, it makes a lot more sense if they were
spaced and not nulled. So this was a shapefile fix not a PG driver fix?
How did the PG as insert statements work, but PG as COPY didn't?
Thank you very much for the help. I'll check this out and run it.
-Andy
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
