[postgis-users] shp2pgsql nulls

Andy Colson andy at squeakycode.net
Wed Sep 28 09:11:39 PDT 2011


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



More information about the postgis-users mailing list