Date/Time Flaw in pg_dump ? - Mailing list pgsql-hackers

From Chris Bitmead
Subject Date/Time Flaw in pg_dump ?
Date
Msg-id 3733FFF4.4DC2C09F@bigfoot.com
Whole thread Raw
In response to Re: [HACKERS] pg_dump problem?  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Using May 2nd snapshot...

If I do a pg_dump <database> | psql <newdatabase>

Any datetime fields are different. I think it's a timezone problem. I
think pg_dump is dumping in local time, and psql is interpreting it as
GMT.

The dump includes the timezone as part of the dump, so I'm guessing that
the problem is on the part of psql not noticing that. I'm using the
Australian "EST" zone if that's useful.

Is there an immediate work-around?


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: MVCC vacuum error
Next
From: Chris Bitmead
Date:
Subject: ODMG interface