Re: "HDT" time zone not recognized by PostreSQL 9.5

On Fri, Sep 23, 2016 at 8:47 PM, Pavol Szegheo <PSzegheo(at)itnnetworks(dot)com> wrote:
> Neither are the more modern HADT and HAST time zones recognized by PostreSQL
> 9.5

The IANA says:

The abbreviations for Hawaii-Aleutian standard and daylight times
have been changed from HAST/HADT to HST/HDT, as per US Government
Printing Office style. This affects only America/Adak since 1983,
as America/Honolulu was already using the new style.

So it looks like HST and HDT should both be accepted but HAST and HADT
should not. "HST" is in the Postgres "Default" abbreviations list but
HDT is missing. There was a push to drop "invented" abbreviations at
some point but it doesn't look at first glance like that ought to have
hit HDT. This may indeed be an unintentional omission, I'm not sure.

The timezonesets are configuration files for Postgres so you should
feel free to edit <pgsqlroot>/share/timezonesets/Default to add HDT or
create your own based on it and set timezone_abbreviations to your new
file. It is listed in America.txt which contains a list of obsolete or
ambiguous abbreviations

--
greg