[postgis-users] shp2pgsql date quirk

Brian Hamlin maplabs at light42.com
Fri Jul 9 00:02:14 PDT 2010

  I am importing several large shape files, into pg 8.4 postgis 1.5+
most went in fine, but the last one failed with an error regarding date 
At least one date field entry in the shape file apparently is "0"
pg complains, the conversion fails..
"Maybe you need different date settings" is suggested..

the database I am importing into already has 60+ tables..
I dont want to change settings on that database to accommodate..

suggestions on an efficient work-around?

Brian Hamlin
OSGeo California Chapter
(415) 717-4462 cell

More information about the postgis-users mailing list