From: | "Trevor Talbot" <quension(at)gmail(dot)com> |
---|---|
To: | "Magnus Hagander" <magnus(at)hagander(dot)net> |
Cc: | "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Zdenek Kotala" <Zdenek(dot)Kotala(at)sun(dot)com>, Devrim GÜNDÜZ <devrim(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: New tzdata available |
Date: | 2007-11-09 01:46:08 |
Message-ID: | 90bce5730711081746h73c570c0k5d48df884b212f11@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 11/8/07, Magnus Hagander <magnus(at)hagander(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-11-09 02:08:34 | Re: [HACKERS] Estimation problem with a LIKE clause containing a / |
Previous Message | Jan Urbański | 2007-11-09 01:22:34 | a tsearch2 (8.2.4) dictionary that only filters out stopwords |