Re: [HACKERS] Aussie timezone database changes incoming

2014-10-05 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
I wrote: Martijn van Oosterhout klep...@svana.org 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

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 klep...@svana.org 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

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

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 into any

Re: [HACKERS] Aussie timezone database changes incoming

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

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 br...@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

Re: [HACKERS] Aussie timezone database changes incoming

2014-10-04 Thread Tom Lane
Bruce Momjian br...@momjian.us 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

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 last

Re: [HACKERS] Aussie timezone database changes incoming

2014-09-14 Thread Tom Lane
Martijn van Oosterhout klep...@svana.org 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

Re: [HACKERS] Aussie timezone database changes incoming

2014-09-11 Thread Robert Haas
On Thu, Sep 11, 2014 at 12:20 AM, Craig Ringer cr...@2ndquadrant.com 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

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 cr...@2ndquadrant.com 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

[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

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:

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 daylight