"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