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 E1mXT5F-0006fK-VY@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_13_STABLE

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

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


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Make Unicode makefile parallel-safe
Next
From: Tom Lane
Date:
Subject: pgsql: Update our mapping of Windows time zone names some more.