[COMMITTERS] pgsql: Update time zone data files to tzdata release 2017b. - Mailing list pgsql-committers

From Tom Lane
Subject [COMMITTERS] pgsql: Update time zone data files to tzdata release 2017b.
Date
Msg-id E1d5DeU-00086k-I5@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Update time zone data files to tzdata release 2017b.

DST law changes in Chile, Haiti, and Mongolia.  Historical corrections for
Ecuador, Kazakhstan, Liberia, and Spain.

The IANA crew continue their campaign to replace invented time zone
abbrevations with numeric GMT offsets.  This update changes numerous zones
in South America, the Pacific and Indian oceans, and some Asian and Middle
Eastern zones.  I kept these abbreviations in the tznames/ data files,
however, so that we will still accept them for input.  (We may want to
start trimming those files someday, but I think we should wait for the
upstream dust to settle before deciding what to do.)

In passing, add MESZ (Mitteleuropaeische Sommerzeit) to the tznames lists;
since we accept MEZ (Mitteleuropaeische Zeit) it seems rather strange not
to take the other one.  And fix some incorrect, or at least obsolete,
comments that certain abbreviations are not traceable to the IANA data.

Branch
------
REL9_5_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/9a8cc157c6e4724770168c589844539ccff2bd05

Modified Files
--------------
src/timezone/data/africa            | 126 ++++----
src/timezone/data/antarctica        |   3 +-
src/timezone/data/asia              | 312 ++++++++++----------
src/timezone/data/australasia       | 159 +++++------
src/timezone/data/backward          |   1 +
src/timezone/data/backzone          | 138 +++++----
src/timezone/data/europe            | 204 +++++++------
src/timezone/data/northamerica      |  95 ++++---
src/timezone/data/southamerica      | 554 ++++++++++++++++++------------------
src/timezone/known_abbrevs.txt      | 113 ++------
src/timezone/tznames/America.txt    | 106 ++-----
src/timezone/tznames/Antarctica.txt |  11 +-
src/timezone/tznames/Asia.txt       |  86 ++----
src/timezone/tznames/Atlantic.txt   |  15 +-
src/timezone/tznames/Australia.txt  |   9 +-
src/timezone/tznames/Default        | 288 ++++++-------------
src/timezone/tznames/Europe.txt     |  11 +-
src/timezone/tznames/Indian.txt     |  24 +-
src/timezone/tznames/Pacific.txt    | 103 +++----
src/timezone/tznames/README         |  12 +-
20 files changed, 1063 insertions(+), 1307 deletions(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: [COMMITTERS] pgsql: libpq: Fix inadvertent change in .pgpass lookup behavior.
Next
From: Tom Lane
Date:
Subject: [COMMITTERS] pgsql: Fix mis-optimization of semijoins with more than one LHSrelatio