Re: BUG #13267: Some timezones in pg_timezone_names are missing in pg_timezone_abbrevs - Mailing list pgsql-bugs

From Berend De Schouwer
Subject Re: BUG #13267: Some timezones in pg_timezone_names are missing in pg_timezone_abbrevs
Date
Msg-id 5550C62B.6000903@gmail.com
Whole thread Raw
In response to Re: BUG #13267: Some timezones in pg_timezone_names are missing in pg_timezone_abbrevs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On 11/05/2015 16:37, Tom Lane wrote:
> berend.de.schouwer@gmail.com writes:
>> Some timezone abbreviations are missing in Postgresql.  For example, 'CAT'
>> (Central African Time)
> CAT is not in the default abbreviation set, but if you have a need for
> it, you can add it to the set of abbreviations accepted by the server.  See
> http://www.postgresql.org/docs/9.3/static/datetime-config-files.html
>
Thank you for the response.

We are working around the problem.  We had already decided to stop using
strings, but instead timestamp values and datetime constructs, etc.
where possible.

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.

It makes for unexpected bugs when the OS, Java and the DB have different
locale and zoneinfo datasets.

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #13148: Unexpected deferred EXCLUDE constraint violation on derived table
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #13148: Unexpected deferred EXCLUDE constraint violation on derived table