Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-09 Thread Greg Stark
On Mon, Oct 8, 2012 at 4:26 PM, Tom Lane t...@sss.pgh.pa.us wrote: for instance IST (the Indians and the Israelis both use this, but not to mean the same thing). And Ireland btw. So I'm not sure if this goes anywhere but could we get away with picking the timezone with the matching

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Simon Riggs
On 6 October 2012 22:40, Tom Lane t...@sss.pgh.pa.us wrote: Thus for example MSK apparently now means GMT+4 not GMT+3. We can change the tznames entry for that, but should we get rid of MSD entirely? Some input from the Russians on this list would be helpful. ... Comments? It shouldn't be

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Heikki Linnakangas
On 08.10.2012 10:03, Simon Riggs wrote: On 6 October 2012 22:40, Tom Lanet...@sss.pgh.pa.us wrote: Thus for example MSK apparently now means GMT+4 not GMT+3. We can change the tznames entry for that, but should we get rid of MSD entirely? Some input from the Russians on this list would be

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Simon Riggs
On 8 October 2012 09:05, Heikki Linnakangas hlinnakan...@vmware.com wrote: * Make the tz file configurable, so people can be more explicit about what *they* mean by certain codes, to avoid the need for choosing between countries. For example, someone may have hardcoded particular codes with

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Marc Balmer
Am 08.10.12 11:07, schrieb Simon Riggs: On 8 October 2012 09:05, Heikki Linnakangas hlinnakan...@vmware.com wrote: * Make the tz file configurable, so people can be more explicit about what *they* mean by certain codes, to avoid the need for choosing between countries. For example, someone

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Simon Riggs
On 8 October 2012 11:14, Marc Balmer m...@msys.ch wrote: So I think we need 2 new settings: one called Postgres92, one called Postgres93. 93 has the new settings and is the default. Default would no longer map to anything, to make sure we have an explicit break of compatibility. Removing

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Could we pull an abbreviation list from one of the BSDs? And that would be authoritative why? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Bruce Momjian
On Mon, Oct 8, 2012 at 11:10:08AM -0400, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Could we pull an abbreviation list from one of the BSDs? And that would be authoritative why? It would be somone else maintaining it. :-) -- Bruce Momjian br...@momjian.us

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Marc Balmer
Am 08.10.12 16:53, schrieb Bruce Momjian: On Mon, Oct 8, 2012 at 12:14:15PM +0200, Marc Balmer wrote: A good starting point would be to take the timezone information directly from the the files IANA distributes, instead of manually copying and maintaining them in a separate file. If no one

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Bruce Momjian
On Mon, Oct 8, 2012 at 05:15:18PM +0200, Marc Balmer wrote: Am 08.10.12 16:53, schrieb Bruce Momjian: On Mon, Oct 8, 2012 at 12:14:15PM +0200, Marc Balmer wrote: A good starting point would be to take the timezone information directly from the the files IANA distributes, instead of

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Tom Lane
Simon Riggs si...@2ndquadrant.com writes: Sorry for any confusion. I've not suggested removing timezone abbreviations, nor do I wish to do so. I did suggest that we do not rely upon TZ abbreviations in any code shipped by PostgreSQL project, but I suspect that is a non-problem anyway. No,

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Heikki Linnakangas
On 08.10.2012 18:26, Tom Lane wrote: The other thing that the abbreviation list files are doing for us is providing a user-configurable way to resolve conflicting abbreviations, for instance IST (the Indians and the Israelis both use this, but not to mean the same thing). This requirement isn't

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Tom Lane
Heikki Linnakangas hlinnakan...@vmware.com writes: On 08.10.2012 18:26, Tom Lane wrote: The other thing that the abbreviation list files are doing for us is providing a user-configurable way to resolve conflicting abbreviations, for instance IST (the Indians and the Israelis both use this, but

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Christopher Browne
On Mon, Oct 8, 2012 at 11:54 AM, Tom Lane t...@sss.pgh.pa.us wrote: Heikki Linnakangas hlinnakan...@vmware.com writes: On 08.10.2012 18:26, Tom Lane wrote: The other thing that the abbreviation list files are doing for us is providing a user-configurable way to resolve conflicting

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Tom Lane
Christopher Browne cbbro...@gmail.com writes: The scenario where we could unambiguously include time zones is where the symbols are unique. If we were to include *all* uniquely-named symbols, that would minimize the number of complaints about missing zones, whilst evading the cases where the

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-08 Thread Joachim Wieland
On Mon, Oct 8, 2012 at 4:00 PM, Tom Lane t...@sss.pgh.pa.us wrote: We can't just refuse to deal with this ambiguity. We have to have some very-low-pain way to install settings that will please those large fractions of our user base. Moreover, if that very-low-pain way isn't the exact same

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-06 Thread Bruce Momjian
The Postgres community does not maintain the timezone database; we ship copies of the IANA timezone database; you will have to request the changes from them: http://www.iana.org/time-zones --- On Sat, Oct 6,

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-06 Thread Marc Balmer
Bruce, The Postgres community does not maintain the timezone database; we ship copies of the IANA timezone database; you will have to request the changes from them: http://www.iana.org/time-zones Please take a second look at the diffs, they do *NOT* change the files in the timezone

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-06 Thread Bruce Momjian
On Sat, Oct 6, 2012 at 02:46:03PM +0200, Marc Balmer wrote: Bruce, The Postgres community does not maintain the timezone database; we ship copies of the IANA timezone database; you will have to request the changes from them: http://www.iana.org/time-zones Please take a

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-06 Thread Tom Lane
Marc Balmer m...@msys.ch writes: These files are maintained by PostgreSQL, there is even a README with an explicit mention that changes should be reported to pgsql-hackers What the README file actually suggests is that periodically we should re-evaluate the set of default abbreviations.

Re: [HACKERS] Add FET to Default and Europe.txt

2012-10-06 Thread Tom Lane
I wrote: What the README file actually suggests is that periodically we should re-evaluate the set of default abbreviations. I looked through the diffs between the 2005m Olson time zone files (which is what we were using at the time the tznames files were created) and current. There are