Attached patch gets rid of the global timezone in the following steps:
Bruce Momjian <bruce@momjian.us>
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 Hagander
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/variable.c | modified | +27 −81 |
| src/backend/postmaster/syslogger.c | modified | +3 −3 |
| src/backend/utils/adt/datetime.c | modified | +3 −2 |
| src/backend/utils/adt/nabstime.c | modified | +3 −3 |
| src/backend/utils/adt/timestamp.c | modified | +2 −2 |
| src/include/pgtime.h | modified | +10 −7 |
| src/timezone/localtime.c | modified | +21 −78 |
| src/timezone/pgtz.c | modified | +117 −10 |
| src/timezone/pgtz.h | modified | +43 −1 |
| src/timezone/strftime.c | modified | +2 −2 |
| src/timezone/zic.c | modified | +2 −2 |