From: | Berend De Schouwer <berend(dot)de(dot)schouwer(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #13267: Some timezones in pg_timezone_names are missing in pg_timezone_abbrevs |
Date: | 2015-05-12 11:22:09 |
Message-ID: | 5551E261.4010603@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 11/05/2015 17:23, Tom Lane wrote:
> Berend De Schouwer <berend(dot)de(dot)schouwer(at)gmail(dot)com> writes:
>> I was just surprised to see that the list of abbrevs in _names is
>> different from the list of abbrevs in _abbrevs. I would have expected
>> the lists to be identical.
> Unfortunately not. If you look a bit closer you will note that many
> time zones use the very same abbreviation for entirely different UTC
> offsets, so we could not possibly make those mappings be inverses.
That's a surprise and a bummer. Ooh. OK, that's a very good reason.
> Another reason for limiting what the server will accept is to reduce
> the scope for errors: even though there is only one meaning for "CAT"
> anywhere in the world, if you are not in Africa then it's quite likely
> that such a string is a typo (perhaps for "CST", which is only one key
> away) and not intended input.
That argument goes both ways :)
Anyway, the server isn't necessarily next to the client, or even on the
same continent.
Thanks for the help.
From | Date | Subject | |
---|---|---|---|
Next Message | cbalmeida | 2015-05-12 12:19:59 | BUG #13275: Version 9.3.6 is not available in Cross distribution packages |
Previous Message | Václav Brodec | 2015-05-12 08:19:39 | Re: BUG #13273: A query that returns wrongly labeled result instead of syntax error |