[postgis-users] shp2pgsql nulls

[Mark Cave-Ayland]

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