Date/Time Flaw in pg_dump ?

From: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
To: pgsql-hackers(at)hub(dot)org
Subject: Date/Time Flaw in pg_dump ?
Date: 1999-05-08 09:12:20
Message-ID: 3733FFF4.4DC2C09F@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Bitmead 1999-05-08 09:32:22 ODMG interface
Previous Message Hiroshi Inoue 1999-05-08 08:57:23 MVCC vacuum error