[postgis-users] shp2pgsql nulls
Mark Cave-Ayland
mark.cave-ayland at siriusit.co.uk
Thu Sep 29 04:00:56 PDT 2011
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
More information about the postgis-users
mailing list