On Thu, Apr 14, 2011 at 12:56:33PM -0500, Jeff Dege wrote:
> ERROR: date/time field value out of range: "0"
> HINT: Perhaps you need a different "datestyle" setting.
>
> What I need is for these features to be inserted with NULL date fields,
> instead of '0'.
You may try to:
1) prepare the ta
I'm trying to load a shapefile into a PostGIS database, using shp2pgsql and
psql.
It's failing because a couple of the sql insert statements have date fields
containing '0'.
ERROR: date/time field value out of range: "0"
HINT: Perhaps you need a different "datestyle" setting.
What I need is