Aug 2021

3 commits
C comment: correct heading of extension query
3 Aug 2021Bruce Momjianmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14beta3REL_13_STABLE13.4+4 more
LLM analysis, 100% surewritten from the discussion, no matching patch1 of 1 reviewer saw the final version

Changes only the stale 'find hash indexes' comment in src/bin/pg_upgrade/version.c to 'find extensions needing updates'; Justin Pryzby reported that copy-and-paste error #101, and Bruce confirmed the correction #102. No attached patch contains this correction.

  • Justin Pryzbysaw the final versionLLM analysis, 100% sureIdentified the incorrect query comment in the newly committed implementation from #94, prompting this correction #101.
pg_upgrade: warn about extensions that need updating
3 Aug 2021Bruce Momjianmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14beta3REL_13_STABLE13.4+4 more
LLM analysis, 100% surelanded as postedfrom patchset #941 of 1 reviewer saw the final version

The complete three-file diff matches #94 exactly apart from abbreviated index hashes, including report_extension_updates(), its call, and generation of update_extensions.sql. Bruce announced application through PostgreSQL 9.6 #100.

  • Tom Lanesaw the final versionLLM analysis, 96% sureProposed querying pg_available_extensions in the new cluster and generating ALTER EXTENSION UPDATE commands for installed nondefault versions #79, which Bruce implemented directly in #94.
pg_upgrade: improve docs about extension upgrades
3 Aug 2021Bruce Momjianmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14beta3REL_13_STABLE13.4+4 more
LLM analysis, 100% surelanded as postedfrom patchset #733 of 3 reviewers saw the final version

Both hunks in doc/src/sgml/ref/pgupgrade.sgml match #73 exactly apart from abbreviated index hashes. Bruce confirmed that the documentation patch was applied to all supported versions #99.

  • David G. Johnstonsaw the final versionLLM analysis, 98% sureReviewed the extension installation and update wording, highlighting ambiguity about copying libraries and proposing clearer instructions #36 #50 #59; subsequent changes were documentation refinements.
  • Dave Cramersaw the final versionLLM analysis, 100% sureChallenged ambiguous copying and recreation language and requested stronger update guidance #37 #41 #54, leading directly to the wording changes in #56.
  • Alvaro Herrerasaw the final versionLLM analysis, 100% sureProposed distinguishing extensions from other loadable modules, avoiding mandatory update wording, and separating full-text search files into their own step #64, all incorporated in #73.

Credits across 3 commits

Author
Bruce MomjianLLM2
Reported by
Dave Cramer2
Justin Pryzby1
Committer
Bruce Momjian3

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