Re: [HACKERS] Aussie timezone database changes incoming

2014-10-04 Thread Jim Nasby
On 10/4/14, 3:25 PM, Bruce Momjian wrote: On Sat, Oct 4, 2014 at 03:01:45PM -0500, Jim Nasby wrote: On 10/4/14, 2:58 PM, Bruce Momjian 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

Re: [HACKERS] Aussie timezone database changes incoming

2014-10-04 Thread Tom Lane
Bruce Momjian writes: > How are Russians supposed to deploy Postgres on October 26 if they use > abbeviations? At midnight? Pretty much. The only bright spot is that the tznames files are just text and can be edited easily, so you can change them when you need to. This isn't the first time thi

Re: [HACKERS] Aussie timezone database changes incoming

2014-10-04 Thread Bruce Momjian
On Sat, Oct 4, 2014 at 05:03:24PM -0400, Tom Lane wrote: > Bruce Momjian 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 > >> ab

Re: [HACKERS] Aussie timezone database changes incoming

2014-10-04 Thread Tom Lane
Bruce Momjian 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-branc

Re: [HACKERS] Aussie timezone database changes incoming

2014-10-04 Thread Bruce Momjian
On Sat, Oct 4, 2014 at 03:01:45PM -0500, Jim Nasby wrote: > On 10/4/14, 2:58 PM, Bruce Momjian 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 int

Re: [HACKERS] Aussie timezone database changes incoming

2014-10-04 Thread Jim Nasby
On 10/4/14, 2:58 PM, Bruce Momjian 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 Fede

Re: [HACKERS] Aussie timezone database changes incoming

2014-10-04 Thread Bruce Momjian
On Sat, Oct 4, 2014 at 02:21:24PM -0400, Tom Lane wrote: > I wrote: > > Martijn van Oosterhout writes: > >> Indeed, this has been a pain in the ass for a long long time. > > > It's good news that people think this will be an improvement. > > > I've not dug into the change details to be sure, bu

Re: [HACKERS] Aussie timezone database changes incoming

2014-10-04 Thread Tom Lane
I wrote: > Martijn van Oosterhout writes: >> Indeed, this has been a pain in the ass for a long long time. > It's good news that people think this will be an improvement. > I've not dug into the change details to be sure, but I think probably > I was overthinking it upthread. We seem to already

Re: [HACKERS] Aussie timezone database changes incoming

2014-09-14 Thread Tom Lane
Martijn van Oosterhout writes: > On Thu, Sep 11, 2014 at 03:42:14PM +1000, Andrew McNamara wrote: >> Quite likely this change will break stuff, but my feeling is more people >> will be cheering than screaming. > Indeed, this has been a pain in the ass for a long long time. It's good news that pe

Re: [HACKERS] Aussie timezone database changes incoming

2014-09-14 Thread Martijn van Oosterhout
On Thu, Sep 11, 2014 at 03:42:14PM +1000, Andrew McNamara wrote: > >Anyone from down under care to remark about the actual usage of old > >and new abbreviations? About bloody time! > > AEST/AEDT/etc are the official abbreviations and are commonly used. > They have been increasingly used over the

Re: [HACKERS] Aussie timezone database changes incoming

2014-09-11 Thread Gavin Flower
On 12/09/14 01:57, Robert Haas wrote: On Thu, Sep 11, 2014 at 12:20 AM, Craig Ringer wrote: I shouldn't be surprised that Australia gets to change. While the cynic in me thinks this is the usual USA-is-the-center-of-the-universe-ism, in reality it makes sense given relative population and likel

Re: [HACKERS] Aussie timezone database changes incoming

2014-09-11 Thread Robert Haas
On Thu, Sep 11, 2014 at 12:20 AM, Craig Ringer wrote: > I shouldn't be surprised that Australia gets to change. While the cynic > in me thinks this is the usual USA-is-the-center-of-the-universe-ism, in > reality it makes sense given relative population and likely impact. Just because it makes se

Re: [HACKERS] Aussie timezone database changes incoming

2014-09-10 Thread Andrew McNamara
>The Russian changes are perhaps not such a big deal because they've >done that sort of thing before, but this is an earful: > > Australian eastern time zone abbreviations are now AEST/AEDT not > EST, and similarly for the other Australian zones. That is, for > eastern standard and day

Re: [HACKERS] Aussie timezone database changes incoming

2014-09-10 Thread Craig Ringer
On 09/10/2014 11:23 PM, Tom Lane wrote: > In connection with a question asked today on pgsql-general, I had > occasion to go check the release announcements for the IANA timezone > database files, and it turns out that there are some big changes in > 2014f: > http://mm.icann.org/pipermail/tz-announ

[HACKERS] Aussie timezone database changes incoming

2014-09-10 Thread Tom Lane
In connection with a question asked today on pgsql-general, I had occasion to go check the release announcements for the IANA timezone database files, and it turns out that there are some big changes in 2014f: http://mm.icann.org/pipermail/tz-announce/2014-August/23.html The Russian changes ar