Patch applied. Thanks. Sorry for the delay in applying.
---
Magnus Hagander wrote:
> Hello!
>
> Attached patch gets rid of the global timezone in the following steps:
>
> * Changes the APIs to the timezone functions to take a pg_tz pointer as
> an argument, representing the timezone to use for the selected
> operation.
>
> * Adds a global_timezone variable that represents the current timezone
> in the backend as set by SET TIMEZONE (or guc, or env, etc).
>
> * Implements a hash-table cache of loaded tables, so we don't have to
> read and parse the TZ file everytime we change a timezone. While not
> necesasry now (we don't change timezones very often), I beleive this
> will be necessary (or at least good) when "multiple timezones in the
> same query" is eventually implemented. And code-wise, this was the time
> to do it.
>
>
> There are no user-visible changes at this time. Implementing the
> "multiple zones in one query" is a later step...
>
> This also gets rid of some of the cruft needed to "back out a timezone
> change", since we previously couldn't check a timezone unless it was
> activated first.
>
> Passes regression tests on win32, linux (slackware 10) and solaris x86.
>
> /Magnus
Content-Description: tz.patch
[ Attachment, skipping... ]
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown Square, Pennsylvania 19073
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster