Re: ROLLBACK of SET TimeZone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alexander M(dot) Pravking" <fduch(at)antar(dot)bryansk(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ROLLBACK of SET TimeZone
Date: 2005-02-14 16:37:21
Message-ID: 29214.1108399041@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Alexander M. Pravking" <fduch(at)antar(dot)bryansk(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-02-14 16:54:19 Re: Bug #1451
Previous Message Adrian Plohn 2005-02-14 14:28:37 Bug #1451