Re: [BUGS] setting time zone during a transaction causes time warp

2003-03-04 Thread Robert Haas
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

Re: [BUGS] setting time zone during a transaction causes time warp

2003-02-19 Thread Tom Lane
"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

[BUGS] setting time zone during a transaction causes time warp

2003-02-19 Thread Robert Haas
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