[gdal-dev] PostgreSQL

[Andy Colson]

Would a 16Meg .zip file, that extracts to 157Meg, be acceptable in Trac? 
  I attempted to copy some records out, but it created the new shapefile 
with a type of ftString instead of ftDate.

-Andy

On 9/28/2011 2:28 PM, Even Rouault wrote:
> 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