Re: Bug #717: timestamp is converted to timestamptz - Mailing list pgsql-bugs

From Thomas Lockhart
Subject Re: Bug #717: timestamp is converted to timestamptz
Date
Msg-id 3D42B5C7.EC4ABA87@fourpalms.org
Whole thread Raw
In response to Bug #717: timestamp is converted to timestamptz  (pgsql-bugs@postgresql.org)
List 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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #722: SELECT FOR UPDATE bug
Next
From: Tom Lane
Date:
Subject: Re: Bug #722: SELECT FOR UPDATE bug