Re: Bug #717: timestamp is converted to timestamptz

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: demolish(at)gtonline(dot)net, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #717: timestamp is converted to timestamptz
Date: 2002-07-27 15:01:27
Message-ID: 3D42B5C7.EC4ABA87@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

...
> When specifying a column data type as timestamp it is always converted to timestamptz.

That is true for 7.2.x and earlier, but 7.3 will have the defaults
reversed.

In the meantime, use explicit WITH TIME ZONE and WITHOUT TIME ZONE
clauses on the declaration.

- Thomas

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-07-27 15:58:45 Re: Bug #722: SELECT FOR UPDATE bug
Previous Message Richard So 2002-07-27 06:45:41 Multi-byte character bug