Getting rid of the global timezone

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "PostgreSQL-patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Getting rid of the global timezone
Date: 2005-03-01 20:08:27
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE476A1B@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

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

Attachment Content-Type Size
tz.patch application/octet-stream 26.6 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Mark Wong 2005-03-01 21:53:10 Re: [PATCHES] WAL: O_DIRECT and multipage-writer (+ memory leak)
Previous Message Bruce Momjian 2005-03-01 18:51:05 Re: Where to see the patch queue (was Re: [PATCHES] Patch for Postmaster