Re: New tzdata available - Mailing list pgsql-hackers

From Trevor Talbot
Subject Re: New tzdata available
Date
Msg-id 90bce5730711081746h73c570c0k5d48df884b212f11@mail.gmail.com
Whole thread Raw
In response to Re: New tzdata available  (Magnus Hagander <magnus@hagander.net>)
Responses Re: New tzdata available  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On 11/8/07, Magnus Hagander <magnus@hagander.net> wrote:

> Andrew Dunstan wrote:
> > Tom Lane wrote:

> >> Are Windows users accustomed to having up-to-the-minute timezone
> >> information?  Maybe there's something I don't know about Microsoft's
> >> update practices, but I would have thought that the expectations on that
> >> platform would be pretty darn low.

> > No, they push updates fairly aggressively. Of course, that's when they
> > have fixes for the problems ... but I would normally expect them to be
> > well on top of timezone changes.

> At least for "common places". They certainly pushed out TZ updates for
> the US changes and the NZ changes recently through their Windows
> Update/Automatic Updates/WSUS service.

Unfortunately, until Vista there was no architecture in place to track
historical changes.  On older versions, the latest zone calendar is
the one that's in effect for all dates (so current US rules apply to
last year's dates too, and we get inaccurate times for them).  The OS
services aren't suitable as a replacement for tzdata.

I've been wondering lately why it isn't just stored in the database somewhere.


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Free Space Map thoughts
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] Estimation problem with a LIKE clause containing a /