[gdal-dev] PostgreSQL

Ivan Price Ivan.Price at noveltis.fr
Wed Sep 28 10:53:18 EDT 2011


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


More information about the gdal-dev mailing list