Re: ROLLBACK of SET TimeZone - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ROLLBACK of SET TimeZone
Date
Msg-id 29214.1108399041@sss.pgh.pa.us
Whole thread Raw
In response to ROLLBACK of SET TimeZone  ("Alexander M. Pravking" <fduch@antar.bryansk.ru>)
List pgsql-bugs
"Alexander M. Pravking" <fduch@antar.bryansk.ru> writes:
> If I don't specify time zone either in config or using "SET TimeZone"
> first, "SET TimeZone" inside a transaction isn't rolled back.

This should work OK in 8.0.  Pre-8.0 it's fundamentally unfixable:
if we cannot see a TZ environment setting, we have no idea what zone the
system timezone library has as default, or how to get it to revert to that.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Adrian Plohn
Date:
Subject: Bug #1451
Next
From: Tom Lane
Date:
Subject: Re: Bug #1451