Re: [postgis-users] shp2pgsql date quirk

2010-07-09 Thread Mark Cave-Ayland

Brian Hamlin wrote:


 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 
fields.

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?
thanks
  -Brian


Hi Brian,

Could you provide us with a shapefile/dbf file containing a few of the 
entries in question?



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


[postgis-users] shp2pgsql date quirk

2010-07-09 Thread Brian Hamlin

 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 
fields.

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?
thanks
  -Brian


==
Brian Hamlin
planetwork.net
OSGeo California Chapter
(415) 717-4462 cell

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users