[gdal-dev] PostgreSQL

[Andy Colson]

> On Thu, Sep 22, 2011 at 9:18 PM, Andy Colson <andy at squeakycode.net <mailto:andy at squeakycode.net>> 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 <mailto:gdal-dev at lists.osgeo.org>
>     http://lists.osgeo.org/__mailman/listinfo/gdal-dev <http://lists.osgeo.org/mailman/listinfo/gdal-dev>
>
>
>
On 09/22/2011 12:48 PM, Chaitanya kumar CH wrote:
> Andy,
>
> Send me the problematic shapefiles and explain what conversions you are trying to perform.
>
>
> --
> Best regards,
> Chaitanya kumar CH.
>
> +91-9494447584
> 17.2416N 80.1426E


Were you able to get the files?  Did you find anything out?

-Andy