Re: DST and potential changes thereto - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: DST and potential changes thereto
Date
Msg-id 20050722202920.GA19066@svana.org
Whole thread Raw
In response to DST and potential changes thereto  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Timezones are implemented using timezones files which contain info
about daylight savings since forever. When/if the change happens a new
set of timezone files should be released. Copy over the one for your
area and you're fine.

Postgresql may use it's own system, I think it depends on the version.
But the same principle applies.

This I what I did when Sydney moved the daylight savings for the
Olympics. I got the file and copied it to all my linux machines. OTOH
the windows machines I never worked out how to do it...

Hope this helps,

On Fri, Jul 22, 2005 at 10:44:49AM -0700, Steve Crawford wrote:
> With the U.S. Government poised to tinker with Daylight Saving Time, I
> have a couple questions.
>
> 0) Does PG rely on system-level TZ info or will specific updates to PG
> be required?  I'm interested in *nix but the Windows folks are
> probably interested, too.
>
> 1) However a change is implemented, what will be the effect on queries
> for historical data? Will the localtime be correct for all dates
> whether before or after the change?
>
> Perhaps we will still dodge this bullet. But with the House and Senate
> recently reaching an agreement, the change is appearing ever more
> likely.
>
> Cheers,
> Steve
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: "Edwin Quijada"
Date:
Subject: Re: [pgsql-es-ayuda] transportar base de datos
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Administration of raster data