pgsql: findtimezone: update Windows timezone name list for recent event

Started by Tom Laneabout 1 month ago1 messagescommitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

findtimezone: update Windows timezone name list for recent events.

The main portion of findtimezone.c's win32_tzmap[] is now directly
generated from the CLDR project's current windowsZones.xml file (using
a script available in the discussion thread, but not yet merged into
our tree). Windows zone names that are no longer present in CLDR are
kept, but are moved to a separate list at the end of the array to
simplify future management.

The important changes that this brings are inclusion of new zone names
for Canada's upcoming timekeeping changes. In addition, this tracks a
few minor changes that CLDR has made in other entries:
"Central Asia Standard Time" now maps to Asia/Bishkek, and
"Mountain Standard Time (Mexico)" now maps to America/Mazatlan.

Reported-by: CyberNative AI <ceo@cybernative.ai>
Author: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: /messages/by-id/179219370621.3670768.16110484606338109870@cybernative.ai
Backpatch-through: 14

Branch
------
REL_18_STABLE

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

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