pgsql: Update our mapping of Windows time zone names some more. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Update our mapping of Windows time zone names some more.
Date
Msg-id E1mXT5G-0006fT-0a@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Update our mapping of Windows time zone names some more.

Per discussion, let's just follow CLDR's default zone mappings
faithfully.  There are two changes here that are clear improvements:

* Mapping "Greenwich Standard Time" to Atlantic/Reykjavik is actually
a better fit than using London, because Iceland hasn't observed DST
since 1968, so this is more nearly what people might expect.

* Since the "Samoa" zone is specified to be UTC+13:00, we must map
it to Pacific/Apia not Pacific/Samoa; the latter refers to American
Samoa which is now on the other side of the date line.

The rest of these changes look like they're choosing the most populous
IANA zone as representative.  Whatever the details, we're just going
to say "if you don't like this mapping, complain to CLDR".

Discussion: https://postgr.es/m/3266414.1633045628@sss.pgh.pa.us

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/cd24791425882a76e890743728f381b7f764cf29

Modified Files
--------------
src/bin/initdb/findtimezone.c | 28 ++++++++++++++--------------
1 file changed, 14 insertions(+), 14 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Update our mapping of Windows time zone names some more.
Next
From: Daniel Gustafsson
Date:
Subject: pgsql: Fix check for trapping exit() calls in libpq