[gdal-dev] PostgreSQL

[Even Rouault]

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.