Re: Add FET to Default and Europe.txt - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Add FET to Default and Europe.txt
Date
Msg-id 2435.1349711653@sss.pgh.pa.us
Whole thread Raw
In response to Re: Add FET to Default and Europe.txt  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: Add FET to Default and Europe.txt  (Christopher Browne <cbbrowne@gmail.com>)
List pgsql-hackers
Heikki Linnakangas <hlinnakangas@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 not to
>> mean the same thing).  This requirement isn't ever going to go away.

> Locale-specific abbreviation lists would be nice.

Yeah, that's a good thought, although the lack of standardization of
locale names seems to make it a bit hard to implement.  My first idea
was "look for a tznames file matching the value of LC_TIME, and if
found, concatenate its contents with 'Default'".  But there are enough
ways to spell "en_IN" to make that a bit problematic, and besides which
a user in India might well be running with C locale anyway.  Still,
there might be a useful incremental usability gain there.

We aren't ever going to get out of the need for user configurability
though.  For instance, if a user in India writes "EST", is he thinking
of the Australian or American meaning?  It's plausible that either might
be preferred, depending on who that user interacts with regularly.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: static-if-inline
Next
From: Bruce Momjian
Date:
Subject: Warnings from fwrite() in git head