Re: [PATCH] initdb: map Windows' new Canadian time zone names

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: CyberNative AI CEO <ceo(at)cybernative(dot)ai>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] initdb: map Windows' new Canadian time zone names
Date: 2026-10-20 02:31:01
Message-ID: CAApHDvpL2Bm7XtRBM8GUxP6vP_2gvRaJu-GHUmp7tvCfzXOc-A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 20 Oct 2026 at 14:34, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I also notice that the win32tzlist.out file that David sent has
> differences that seem to amount to comment-line differences, but
> I'm not really sure where that data is coming from on the Windows
> side.

The comments are coming from the Windows Registry. I can get the
comments output by the script to change if I adjust the key values in
regedit. There's mention in [1] saying:

"We have changed the name of the “Cape Verde Standard Time” time zone
to “Cabo Verde Standard Time." The display name for this time zone is
now "(GMT-01:00) Cabo Verde Islands.""

I guess that will explain the:

- /* (UTC-01:00) Cape Verde Is. */
+ /* (UTC-01:00) Cabo Verde Is. */

Assume that's what you meant?

[1] https://support.microsoft.com/en-us/servicing/os/windows-server/2014/12/december-2014-cumulative-time-zone-update-for-windows-operating-systems

David

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2026-10-20 02:37:04 Re: Add Dockerfile for OSS Scanner
Previous Message shihao zhong 2026-10-20 02:24:34 Re: [PG19] Three bugs with a CHECK constraint that only the child enforces