On Thu, Sep 22, 2011 at 9:18 PM, Andy Colson <a...@squeakycode.net <mailto:a...@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@lists.osgeo.org <mailto:gdal-dev@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 _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
