Mar 2020

2 commits
Prevent reindex of invalid indexes on TOAST tables
10 Mar 2020Michael Paquiermaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1+1 moreAlso in: REINDEX CONCURRENTLY 2.0 (not this thread)
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #281 of 1 reviewer saw the final version

The commit matches the four-file fix in #28, with IsToastNamespace() replacing PG_TOAST_NAMESPACE comparisons to include temporary TOAST namespaces, a cached namespace OID, and revised diagnostics/comments; the patch and commit explicitly credit Julien Rouhaud. This March 2020 source is newer than all supplied patchsets in thread #30398, which supplied the historical report rather than this fix.

  • Michael Paquiersaw the final versiontrailerMichael identified missing index-level checks in #9, corrected the ordinary-index restriction in #17, supplied the revised checks in #28, and committed the final version as confirmed in #38.
Fix more issues with dependency handling at swap phase of REINDEX CONCURRENTLY
5 Mar 2020Michael Paquiermaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1+1 more
LLM analysis, 100% surelanded as postedfrom patchset #131 of 1 reviewer saw the final version

The src/backend/catalog/index.c diff matches #13 exactly, including both new-to-old dependency calls and the CommandCounterIncrement() warning; Michael confirmed application in #15.

  • Julien Rouhaudsaw the final versiontrailerJulien reviewed the fix and reported successful testing of multiple failure scenarios in #14 before the unchanged patch was committed.

Credits across 2 commits

Author
Julien Rouhaud1
Michael Paquier1
Reviewer
Julien Rouhaud1
Michael Paquier1
Reported by
Julien Rouhaud1
Justin Pryzby1
Sergei Kornilov1
Committer
Michael Paquier2