May 2021

1 commit
Make detach-partition-concurrently-4 less timing sensitive
25 May 2021Alvaro Herreramaster14beta2REL_19_STABLE14beta2REL_18_STABLE14beta2REL_17_STABLE14beta2REL_16_STABLE14beta2REL_15_STABLE14beta2REL_14_STABLE14beta2
LLM analysis, 100% surewritten from the discussion, no matching patch

Implements the test stabilization proposed in #90: a no-op after cancellation and a short sleep in detach-partition-concurrently-4, with updated expected output; no matching patchset was attached.

Apr - May 2021

5 commits
Improve documentation on DETACH PARTITION lock levels
6 May 2021Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #821 of 1 reviewer saw the final version

Uses both documentation changes from #82, adding an explicit concurrent-detach example and revising the wording and link presentation as described in #86.

  • Alvaro Herrerasaw the final versioncommittercommitted the patch
Track detached partitions more accurately in partdescs
6 May 2021Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #801 of 1 reviewer saw the final version

Preserves the descriptor-classification fix from #80 in partdesc.c and rel.h, additionally replacing the cached-xmin validity guard with an assertion of the new invariant.

  • Alvaro Herrerasaw the final versioncommittercommitted the patch
Allow a partdesc-omitting-partitions to be cached
28 Apr 2021Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #781 of 1 reviewer saw the final version

The code and tests match #78; the only additional diff documents that at most one partition may be pending detach, confirmed in #79.

  • Amit Langotesaw the final versionLLM analysis, 100% sureAmit identified cache-reset and memory-context failures in #73, then confirmed the revised code worked and requested the final readability changes in #77.
Fix relcache inconsistency hazard in partition detach
22 Apr 2021Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #61

Combines both patches in #61, with comments and consistent omit_detached API naming requested in #63; the patch and commit credit Amit Langote and Alvaro Herrera as co-authors.

Don't add a redundant constraint when detaching a partition
21 Apr 2021Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #511 of 1 reviewer saw the final version

Implements #51 with DetachAddConstraintIfNeeded reorganized to pass implicit-AND constraints directly to PartConstraintImpliedByRelConstraint, as explained in #62.

  • Álvaro Herrerasaw the final versiontrailerThe committer verified that the existing constraint avoids a scan on reattachment and corrected the implication-check input representation in #62.

Mar 2021

2 commits
ALTER TABLE ... DETACH PARTITION ... CONCURRENTLY
25 Mar 2021Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 99% surepart of a posted patchsetmoderate changesfrom patchset #470 of 2 reviewers saw the final version

Lands the feature portion of #47, whose prerequisite landed separately, with expanded cursor/FK/freeze tests, documentation edits, a catalog-version bump, and snapshot waiting moved into ATExecDetachPartitionFinalize.

  • Amit Langotesaw an earlier versiontrailerAmit found argument-order and routing problems in #13 and #15, before the substantial snapshot-visibility rework in #47.
  • Justin Pryzbysaw an earlier versiontrailerJustin reviewed documentation and constraint races in #25, supplied #29, and tested the constraint fixes in #34 and #36 before the final visibility redesign.
Let ALTER TABLE Phase 2 routines manage the relation pointer
25 Mar 2021Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #47

Lands only the relation-pointer prerequisite from the two-patch submission #47; its tablecmds.c changes match that component exactly.

Sep 2020

1 commit
Check default partitions constraints while descending
8 Sep 2020Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1REL_13_STABLE13rc1+1 moreAlso in: default partition and concurrent attach partition (part of a posted patchset)

Credits across 9 commits

Author
Alvaro Herrera1 LLM5
Amit Langote4
Justin Pryzby1
Reviewer
Alvaro Herreracommitter3
Amit Langote1
Justin Pryzby1
Reported by
Pavel Luzanov1
Committer
Alvaro Herrera9

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