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

Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> writes:
>> On Sat, Sep 24, 2016 at 7:52 AM, <pszegheo(at)itnnetworks(dot)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