Dec 2024 - Jan 2025

5 commits
Use @extschema:name@ notation in contrib transform modules.
9 Jan 2025Tom Lanemaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% surelanded as postedfrom patchset #40

The complete seven-file patch in #40 has the same stable patch ID as the commit, including the transform scripts and all three documentation changes.

pg_freespacemap: Fix declaration of pg_freespace(regclass)
8 Jan 2025Michael Paquiermaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #421 of 1 reviewer saw the final version

The commit applies the one-line pg_freespacemap repair from #42, replacing 0::bigint and 1::bigint with quoted numeric literals cast to bigint. Noah requested this constant-node optimization in #43, and Michael confirmed its adoption in #44.

  • Noah Mischsaw the final versiontrailerNoah demonstrated the capture vulnerability in #41 and reviewed #42 in #43, requesting the quoted-literal form used in the commit.
contrib/pageinspect: Use SQL-standard function bodies.
29 Dec 2024Tom Lanemaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% surepart of a posted patchsetmoderate changesfrom patchset #240 of 1 reviewer saw the final version

Lands the pageinspect component of #24, whose patch header credits Tom Lane, with rel_oid explicitly cast to oid and both functions changed from PARALLEL SAFE to PARALLEL RESTRICTED. Tom explains the parallel restriction in #39.

  • Noah Mischsaw an earlier versionLLM analysis, 91% sureNoah identified installation-time capture through inexact argument matching in #2 and #4; the later pageinspect version added an exact oid cast and corrected parallel safety.
contrib/xml2: Use SQL-standard function bodies.
29 Dec 2024Tom Lanemaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 99% surepart of a posted patchsetmoderate changesfrom patchset #371 of 3 reviewers saw the final version

Lands the xml2 component forwarded by Tom in #37 from Ronan's #31, adding explicit ::text casts to the literal arguments of xpath_list() and xpath_nodeset(). The commit credits both Tom Lane and Ronan Dunklau.

  • Noah Mischsaw an earlier versionLLM analysis, 93% sureNoah raised the inexact-match security problem for the original conversions in #2 and #4, before the committed xml2 bodies acquired explicit text casts.
  • Michael Paquiersaw an earlier versionLLM analysis, 99% sureMichael found that the converted xml2 functions lacked regression coverage in #30, prompting the tests in #31, before Tom's later argument-cast changes.
  • Tom Lanesaw the final versioncommittercommitted the patch
contrib/citext: Use SQL-standard function bodies.
29 Dec 2024Tom Lanemaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 99% surepart of a posted patchsetlight changesfrom patchset #372 of 2 reviewers saw the final version

Lands the citext component forwarded in #37 from Ronan's #31, with redundant pg_catalog qualification removed from text casts throughout contrib/citext/citext--1.7--1.8.sql. The commit credits both Tom Lane and Ronan Dunklau.

  • Noah Mischsaw the final versionLLM analysis, 89% sureNoah reviewed the original conversions' installation-time security in #2 and #4, and the citext component subsequently received only version, parameter-name, build-registration and redundant-qualification changes.
  • Tom Lanesaw the final versioncommittercommitted the patch

Dec 2024

1 commit
contrib/earthdistance: Use SQL-standard function bodies.
14 Dec 2024Tom Lanemaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1REL_17_STABLE17.3REL_16_STABLE16.7Also in: Errors when restoring backup created by pg_dumpall (not this thread)
LLM analysis, 100% surepart of a posted patchsetmoderate changesfrom patchset #310 of 2 reviewers saw the final version

Lands the earthdistance component of #31, retaining its SQL-body conversions but using explicitly typed float8 constants and hardening CREATE DOMAIN in the existing earthdistance--1.1.sql instead of adding the proposed new base script. Tom explains these changes in #36, and the commit credits him and Ronan.

  • Noah Mischsaw an earlier versionLLM analysis, 98% sureNoah identified inexact function and operator matching as an installation-time security hazard in #2 and #4, before the later schema qualification and exact-type changes.
  • Mark Dilgersaw an earlier versionLLM analysis, 96% sureMark proposed extending schema substitution to resolve earthdistance's references to cube in #7, an approach adopted in the revived patch and committed implementation.

Nov 2024

4 commits
contrib/lo: Use SQL-standard function bodies
14 Nov 2024Michael Paquiermaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #311 of 1 reviewer saw the final version

Lands only the lo conversion component of #31, with an identical stable patch ID and no edits to its four files. Michael explicitly confirms applying it as proposed in #34.

  • Michael Paquiersaw the final versioncommittercommitted the patch
xml2: Add tests for functions xpath_nodeset() and xpath_list()
14 Nov 2024Michael Paquiermaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #311 of 1 reviewer saw the final version

Lands the xml2 test component of #31, reordering and formatting the same five queries and adding their missing alternate expected output in contrib/xml2/expected/xml2_1.out. Michael reports correcting that omission in #34.

  • Michael Paquiersaw the final versioncommittercommitted the patch
contrib/lo: Add test for function lo_oid()
14 Nov 2024Michael Paquiermaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #311 of 1 reviewer saw the final version

Lands only the lo_oid() regression-test component of #31, with an identical stable patch ID. The SQL test and expected output are unchanged, as confirmed in #34.

  • Michael Paquiersaw the final versioncommittercommitted the patch
pg_freespacemap: Use SQL-standard function bodies
12 Nov 2024Michael Paquiermaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #242 of 2 reviewers saw the final version

Lands the pg_freespacemap component of #24 with an identical stable patch ID across its four files. Both the submitted patch header and commit identify Tom Lane as author, while Ronan supplied the updated series.

  • Ronan Dunklausaw the final versiontrailerRonan refreshed Tom's conversion in #22 and supplied its missing Meson installation entry in #24, whose pg_freespacemap component was committed unchanged.
  • Michael Paquiersaw the final versioncommittercommitted the patch

Credits across 10 commits

Author
Ronan Dunklau2 LLM5
Tom Lane3 LLM4
Michael PaquierLLM1
Reviewer
Michael Paquiercommitter4
Tom Lanecommitter2
Noah Misch1
Ronan Dunklau1
Reported by
Noah Misch1
Committer
Michael Paquier5
Tom Lane5

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