Oct 2023

5 commits
Back-patch test cases for timetz_zone/timetz_izone.
17 Oct 2023Tom LaneREL_16_STABLE16.1REL_15_STABLE15.5REL_14_STABLE14.10REL_13_STABLE13.13REL_12_STABLE12.17REL_11_STABLE11.22
LLM analysis, 96% surepart of a posted patchsetlight changesfrom patchset #451 of 1 reviewer saw the final version

Combines the test-only portion of #45 with earlier timetz coverage from #18 and 2f04720307, adapting it for older branches without AT LOCAL. The date.c repair is deliberately omitted so buildfarm runs can establish whether those branches fail.

  • Michael Paquiersaw the final versionLLM analysis, 78% sureReviewed the original timetz tests in #19, raised older-branch reproduction in #38, and supported back-patching the coverage in #40, with only test adaptations following.
Dodge a compiler bug affecting timetz_zone/timetz_izone.
17 Oct 2023Tom Lanemaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16.1REL_15_STABLE15.5REL_14_STABLE14.10REL_13_STABLE13.13+2 more
LLM analysis, 100% surelanded as postedfrom patchset #451 of 1 reviewer saw the final version

The complete diff matches #45 after ignoring abbreviated index hashes, including both date.c changes and the negative-wrap regression cases.

  • Michael Paquiersaw the final versionLLM analysis, 97% sureProposed the exact guarded-modulo replacement inline in #43, which Tom adopted in #45 and explicitly credited in the commit.
Add regression test coverage for timetz_izone().
16 Oct 2023Tom Lanemaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1
LLM analysis, 100% surewritten from the discussion, no matching patch

Implements Tom Lane's coverage proposal in #39 by adding AT TIME ZONE INTERVAL '00:00' to the committed timetz test view and updating its expected output. No attached patchset contains this change before its commit.

Add support for AT LOCAL
13 Oct 2023Michael Paquiermaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #181 of 3 reviewers saw the final version

Preserves the grammar, unary timezone functions and deparser from #18, with test-view presentation changes, a temporary timezone-name variable, catalog-entry relocation and a catalog-version bump. As confirmed in #19, one independent documentation paragraph was extracted first.

  • Laurenz Albesaw an earlier versiontrailerQuestioned execution-time timezone resolution in #2 and accepted Vik's explanation in #4, before the dedicated-function redesign.
  • Cary Huangsaw an earlier versiontrailerReported successful feature, specification, documentation and installcheck-world testing in #9, before the dedicated-function redesign and timetz extension.
  • Michael Paquiersaw the final versiontrailerRequested the single-function design, benchmarked it, expanded documentation, requested timetz support and reviewed and committed the final version as described in #19.
doc: Mention timezone(zone, time) in section for AT TIME ZONE
13 Oct 2023Michael Paquiermaster17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #181 of 1 reviewer saw the final version

Extracts the doc/src/sgml/func.sgml paragraph equating timezone(zone, time) with time AT TIME ZONE zone from #18, with line wrapping adjusted. Michael explicitly confirms the extraction in #19.

  • Michael Paquiersaw the final versioncommittercommitted the patch

Credits across 5 commits

Author
Tom LaneLLM2
Vik Fearing2
Reviewer
Michael Paquiercommitter2
Cary Huang1
Laurenz Albe1
Committer
Tom Lane3
Michael Paquier2

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