pgsql: Update time zone abbreviations lists.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Update time zone abbreviations lists.
Date: 2014-10-03 21:46:29
Message-ID: E1XaAgH-0000sj-S5@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Update time zone abbreviations lists.

This updates known_abbrevs.txt to be what it should have been already,
were my -P patch not broken; and updates some tznames/ entries that
missed getting any love in previous timezone data updates because zic
failed to flag the change of abbreviation.

The non-cosmetic updates:

* Remove references to "ADT" as "Arabia Daylight Time", an abbreviation
that's been out of use since 2007; therefore, claiming there is a conflict
with "Atlantic Daylight Time" doesn't seem especially helpful. (We have
left obsolete entries in the files when they didn't conflict with anything,
but that seems like a different situation.)

* Fix entirely incorrect GMT offsets for CKT (Cook Islands), FJT, FJST
(Fiji); we didn't even have them on the proper side of the date line.
(Seems to have been aboriginal errors in our tznames data; there's no
evidence anything actually changed recently.)

* FKST (Falkland Islands Summer Time) is now used all year round, so
don't mark it as a DST abbreviation.

* Update SAKT (Sakhalin) to mean GMT+11 not GMT+10.

In cosmetic changes, I fixed a bunch of wrong (or at least obsolete)
claims about abbreviations not being present in the zic files, and
tried to be consistent about how obsolete abbreviations are labeled.

Note the underlying timezone/data files are still at release 2014e;
this is just trying to get us in sync with what those files actually
say before we go to the next update.

Branch
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/cc7bad30cdb39397fe4e5aeb5c1e6aaa77ca49ee

Modified Files
--------------
src/timezone/known_abbrevs.txt | 115 ++++++++++++++++---------------------
src/timezone/tznames/America.txt | 13 ++---
src/timezone/tznames/Asia.txt | 47 +++++----------
src/timezone/tznames/Atlantic.txt | 8 +--
src/timezone/tznames/Default | 60 +++++++++----------
src/timezone/tznames/Europe.txt | 2 -
src/timezone/tznames/Pacific.txt | 12 ++--
7 files changed, 104 insertions(+), 153 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2014-10-03 22:06:13 Re: pgsql: Fix CreatePolicy, pg_dump -v; psql and doc updates
Previous Message Stephen Frost 2014-10-03 20:33:20 pgsql: Fix CreatePolicy, pg_dump -v; psql and doc updates