Andy,<br><br>Send me the problematic shapefiles and explain what conversions you are trying to perform.<br><br><div class="gmail_quote">On Thu, Sep 22, 2011 at 9:18 PM, Andy Colson <span dir="ltr"><<a href="mailto:andy@squeakycode.net">andy@squeakycode.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi List,<br>
<br>
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:<br>
<br>
ERROR 1: COPY statement failed.<br>
ERROR: date/time field value out of range: "0000/00/00"<br>
CONTEXT: COPY parcelannov2, line 18, column recorded: "0000/00/00"<br>
<br>
Inserts are really slow, so I'd love to use copy instead.<br>
<br>
On another layer, regardless of insert/copy, I'm getting:<br>
<br>
ERROR: numeric field overflow<br>
DETAIL: A field with precision 19, scale 11 must round to an absolute value less than 10^8.<br>
CONTEXT: COPY poltwppoly, line 1, column shape_area: "1005965403.24000000954"<br>
<br>
I'm using: GDAL 1.9dev, released 2011/01/18<br>
<br>
I can make the shapefiles available if it would be of help. Is there anything else I can do/try/offer?<br>
<br>
Thanks,<br>
<br>
-Andy<br>
______________________________<u></u>_________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/gdal-dev</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Best regards,<br>Chaitanya kumar CH.<br><br>+91-9494447584<br>17.2416N 80.1426E<br>