Sep - Oct 2021

5 commits
Doc: improve timezone/README's recipe for tracking Windows zones.
6 Oct 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 99% surewritten from the discussion, no matching patch

Neither attachment changes src/timezone/README; this commit documents the decision to follow CLDR's territory=001 defaults reached in #16 and #22. It also preserves the Windows registry inspection procedure and the instruction to retain older zone names.

Update our mapping of Windows time zone names some more.
4 Oct 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14.1REL_13_STABLE13.5+4 more
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #151 of 1 reviewer saw the final version

The commit includes all eight mapping replacements attached in #15, applied to src/bin/initdb/findtimezone.c. It additionally maps Central America to America/Guatemala and Greenwich Standard Time to Atlantic/Reykjavik, with explanatory comments, following #18 and #22.

  • Thomas Munrosaw the final versionLLM analysis, 94% sureHe examined the remaining mappings, challenged the London choice, identified suspicious Samoa and other entries, and proposed following CLDR completely, covering the policy and additional mappings adopted before this commit #16 #18 #22.
Update our mapping of Windows time zone names using CLDR info.
2 Oct 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14.1REL_13_STABLE13.5+4 more
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #11

This implements the mapping work from #11, with the ordering changes split into ad740067ae. Further edits retain older Jerusalem and Russian zone names, add a UTC entry, correct six Etc/GMT offset mappings, and explain the CLDR source and Greenwich exception, consistent with the additional fixes reported in #15.

Re-alphabetize the win32_tzmap[] array.
2 Oct 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14.1REL_13_STABLE13.5+4 more
LLM analysis, 100% surepart of a posted patchsetmoderate changesfrom patchset #11

This extracts only the win32_tzmap[] entry movements from #11, including Bougainville, Chatham, Easter Island, Malay Peninsula, Sakhalin, Tonga, and Coordinated Universal Time. The attachment's substantive mapping corrections were committed separately in 9b8d68cc65.

Remove gratuitous environment dependency in 002_types.pl test.
30 Sep 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14.1REL_13_STABLE13.5+3 more
LLM analysis, 100% surewritten from the discussion, no matching patch

The three replacements in src/test/subscription/t/002_types.pl implement Tom Lane's proposal to replace timezone-sensitive interval subtraction with timestamp constants #5. Both attachments concern Windows mappings and were posted later; Andres Freund's approval and successful retest also postdate this commit #9 #10.

Credits across 5 commits

Author
Tom LaneLLM3
Committer
Tom Lane5

N LLM means N of the credits come from LLM analysis, not from commit trailers.