Re: BUG #13267: Some timezones in pg_timezone_names are missing in pg_timezone_abbrevs

On 11/05/2015 16:37, Tom Lane wrote:
> berend(dot)de(dot)schouwer(at)gmail(dot)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.