forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit9b8d68c
committed
Update our mapping of Windows time zone names using CLDR info.
This corrects a bunch of entries in win32_tzmap[], and adds a fewnew ones, based on the CLDR project's windowsZones.xml file.Non-cosmetic changes fall into four main categories:* Flat-out errors:US/Aleutan doesn't existAmerica/Salvador doesn't existAsia/Baku is wrong for YerevanAsia/Dhaka (Bangladesh) is wrong for Astana (Kazakhstan)Europe/Bucharest is wrong for ChisinauAmerica/Mexico_City is wrong for ChetumalAmerica/Buenos_Aires is wrong for CayenneAmerica/Caracas has its own zone, so poor fit for La PazUS/Eastern is wrong for HaitiUS/Eastern is wrong for Indiana (East)Asia/Karachi is wrong for TashkentEtc/UTC+12 doesn't existSigns of Etc/GMT zones were backwards* Judgment calls:(These changes follow CLDR's choices, except for the first one)Use Europe/London for "Greenwich Standard Time", since that seems muchmore likely than Africa/Casablanca to be what people will think thatzone name means. CLDR has Atlantic/Reykjavik here, but that's no better.Asia/Shanghai seems a better fit than Hong Kong for "China StandardTime".Europe/Sarajevo is now a link to Belgrade, ie "Central Europe StandardTime"; so use Warsaw for "Central European Standard Time".America/Sao_Paulo seems more representative than Araguaina for"E. South America Standard Time".Africa/Johannesburg seems more representative than Harare for"South Africa Standard Time".* New Windows zone names:"Israel Standard Time""Kaliningrad Standard Time""Russia Time Zone N" for various N"Singapore Standard Time""South Sudan Standard Time""W. Central Africa Standard Time""West Bank Standard Time""Yukon Standard Time"Some of these replace older spellings, but I kept the older spellingstoo in case our code runs on a machine with the older data.* Replace aliases (tzdb Links) with underlying city-named zones:(This tracks tzdb's longstanding practice, and reduces inconsistencywith the rest of the entries, as well as with CLDR.)US/AlaskaAsia/KuwaitAsia/MuscatCanada/AtlanticAustralia/CanberraCanada/SaskatchewanUS/CentralUS/EasternUS/HawaiiUS/MountainCanada/NewfoundlandUS/PacificBack-patch to all supported branches, as is our usual practice fortime zone data updates.Discussion:https://postgr.es/m/3266414.1633045628@sss.pgh.pa.us1 parentad74006 commit9b8d68c
1 file changed
+106
-51
lines changed0 commit comments
Comments
(0)