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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: findtimezone: update Windows timezone name list for recent event
Date: 2026-10-21 15:53:10
Message-ID: E1xJYco-00000000Cqb-2U7w@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(at)cybernative(dot)ai>
Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: https://postgr.es/m/179219370621.3670768.16110484606338109870@cybernative.ai
Backpatch-through: 14

Branch
------
REL_19_STABLE

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

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

Browse pgsql-committers by date

  From Date Subject
Next Message Masahiko Sawada 2026-10-21 17:45:53 pgsql: Reject COPY TO of unlogged tables during recovery.
Previous Message Fujii Masao 2026-10-21 14:42:28 pgsql: Report shared buffer exhaustion as insufficient resources