etting time zone during
a transaction causes time warp
"Robert Haas" <[EMAIL PROTECTED]>
writes:
> While using PostgreSQL 7.2.3, I discovered that if I set the time
zone
> during the transaction, "now" takes on an incorrect value
for the
> remainder of that tran
"Robert Haas" <[EMAIL PROTECTED]> writes:
> While using PostgreSQL 7.2.3, I discovered that if I set the time zone
> during the transaction, "now" takes on an incorrect value for the
> remainder of that transaction.
The problem seems to be restricted to the result of 'now'::timestamptz,
and not
While using PostgreSQL 7.2.3, I discovered that if
I set the time zone during the transaction, "now" takes on an
incorrect value for the remainder of that transaction. Once the transaction
is committed, everything goes back to normal. I've reproduced the
problem below using the "psql" client. T