Re: BUG #14337: "HDT" time zone is not recognized by PostreSQL 9.5

Thomas Munro <thomas.munro@enterprisedb.com> writes:
>> On Sat, Sep 24, 2016 at 7:52 AM,  <pszegheo@itnnetworks.com> wrote:
>>> "HDT" time zone is not recognized by PostreSQL 9.5

> Hmm.  src/timezone/data/northamerica does reference HDT though:

Actually, some further digging finds this:

Zone America/Adak     12:13:21 -    LMT    1867 Oct 18
            -11:46:38 -    LMT    1900 Aug 20 12:00
            -11:00    -    NST    1942
            -11:00    US    N%sT    1946
            -11:00    -    NST    1967 Apr
            -11:00    -    BST    1969
            -11:00    US    B%sT    1983 Oct 30  2:00
            -10:00    US    AH%sT    1983 Nov 30
            -10:00    US    H%sT

So this zone really is using HDT to refer to UTC-9.  But it's someplace
in the Aleutians, not Hawaii, and Wikipedia says the total population of
Adak is 326.  So I remain dubious that we want to add HDT to the standard
abbreviation list --- there are mighty few people for whom it wouldn't be
a typo.

I see we do list it in the tznames/America.txt data file:

HADT   -32400 D  # Hawaii-Aleutian Daylight Time (obsolete abbreviation)
                 #     (America/Adak)
HAST   -36000    # Hawaii-Aleutian Standard Time (obsolete abbreviation)
                 #     (America/Adak)
HDT    -32400 D  # Hawaiian-Aleutian Daylight Time
                 #     (America/Adak)

and that seems like the appropriate treatment.

            regards, tom lane