Re: Aussie timezone database changes incoming - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Aussie timezone database changes incoming
Date
Msg-id 20714.1412456604@sss.pgh.pa.us
Whole thread Raw
In response to Re: Aussie timezone database changes incoming  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Aussie timezone database changes incoming
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> On Sat, Oct  4, 2014 at 02:21:24PM -0400, Tom Lane wrote:
>> I've committed changes for this in advance of the upcoming 9.4beta3
>> release.  Hopefully, if this is seriously bad for anyone, we'll hear
>> about it from beta testers before it gets into any official back-branch
>> releases.

> The changes for the Russian Federation timezones taking effect October
> 26 reinforces our need to get a new set of minor releases out soon.  In
> fact, those storing future dates might already need those updates.

Well, the other side of that coin is that those new abbreviation values
aren't valid *yet*.

It's becoming clear to me that our existing design whereby zone
abbreviations represent fixed GMT offsets isn't really good enough.
I've been wondering whether we could change things so that, for instance,
"EDT" means "daylight time according to America/New_York" and the system
would consult the zic database to find out what the prevailing GMT offset
was in that zone on that date.  This would be a lot more robust in the
face of the kind of foolishness we now see actually goes on.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Aussie timezone database changes incoming
Next
From: Bruce Momjian
Date:
Subject: Re: Aussie timezone database changes incoming