Re: Error: Bad Timestamp Format

Martijn van Oosterhout wrote:

> > vendirza=# SHOW DATESTYLE;
> > NOTICE: DateStyle is ISO with US (NonEuropean) conventions
> >
> > vendirza=# SHOW DATESTYLE;
> > NOTICE: DateStyle is ISO with US (NonEuropean) conventions
>
> Looks the same machine to me.

That's because both machines are configured the same.

> BTW, i don't know who thought of it but yyyy-dd-mm is a terrible format and
> should be shot.

Yep.

> Check the datestypes. Try setting it to european conventions, maybe that
> will work better

I thought that is what I was doing with "SHOW DATETYPES".

What format is the date "2001-09-12 14:14:12.03-04"?
^^-- day

> Does pg_dump make a difference?

pg_dump seems to be useless - it doesn't dump the whole database (blobs
in the DB are missing).

Regards,
Graham
--
-----------------------------------------
minfrin(at)sharp(dot)fm "There's a moon
over Bourbon Street
tonight..."