On 28/09/11 17:11, Andy Colson wrote:
Hi List,
I have a shapefile and using ogr2ogr to reproject it, then shp2pgsql to
import it, but a date column has nulls in it and I'm getting invalid
date errors. If I dont use ogr2ogr the nulls import fine (the dest table
has nulls as well).
It looks like ogr2ogr is using a newer version of shapelib and is
writing null fields a little bit differently? (I'm guessing here.) Would
it be possible to update shp2pgsql to a newer version of shapelib?
-Andy
Hi Andy,
I think we'd need to have an example shapefile with a small sample of
geometries to understand what's going on here. Also you didn't mention
which version of shp2psql you are using, as there has been a lot of work
done there in recent times.
ATB,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
