[gdal-dev] PostgreSQL

[Andy Colson]

They use a slightly older version of shapelib that doesnt quite work 
with null's.  If I ogr2ogr shapefile -> shapefile (to get it in the 
projection I want), then shp2pgsql will fail with fields that are null.

Which, I could to ask them to update, yes.  It was a 50/50.  Ask gdal or 
ask postgis.

-Andy

On 9/28/2011 9:53 AM, Ivan Price wrote:
> is there a reason you don't want to use shp2pgsql ?
>
> not sure if its better for everything but i've used it on occasion when i had a prob in ogr2ogr
>
> -i
>
>
>
> -----Message d'origine-----
> De : gdal-dev-bounces at lists.osgeo.org [mailto:gdal-dev-bounces at lists.osgeo.org] De la part de Andy Colson
> Envoyé : Wednesday, 28 September 2011 4:50 PM
> À : gdal-dev at lists.osgeo.org
> Objet : Re: [gdal-dev] PostgreSQL
>
> Sorry to keep pestering.  Is there a better place I should be seeking help?  Would a $bounty$ help?
>
> -Andy
>
> On 9/22/2011 10:48 AM, Andy Colson wrote:
>> 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.
>>
>> 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"
>>
>> 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
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev