Jun 2019

1 commit
Make pg_dump emit ATTACH PARTITION instead of PARTITION OF (reprise)
10 Jun 2019Alvaro Herreramaster12beta2REL_19_STABLE12beta2REL_18_STABLE12beta2REL_17_STABLE12beta2REL_16_STABLE12beta2REL_15_STABLE12beta2REL_14_STABLE12beta2REL_13_STABLE12beta2+3 moreAlso in: pg_dump: fail to restore partition table with serial type (modified before commit)Also in: pg_dump partitions can lead to inconsistent state after restore

Apr 2019

2 commits
Fix tablespace inheritance for partitioned rels
25 Apr 2019Alvaro Herreramaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% suremodified before commitlight changesfrom patchset #560 of 3 reviewers saw the final version

The backend implementation matches #56; the commit restores earlier regression tests, adds tablespace documentation, and bumps src/include/catalog/catversion.h. Alvaro confirms the restored tests and documentation additions in #57.

  • Tom Lanesaw an earlier versionLLM analysis, 94% sureIn #33, challenged the reltablespace invariant violation in #32, which was removed by the substantial redesign in #56.
  • Robert Haassaw an earlier versionLLM analysis, 95% sureIn #36, demonstrated how storing the database tablespace OID would split existing and future partitions after database relocation, prompting Alvaro's redesign in #37.
  • David Rowleysaw an earlier versionLLM analysis, 88% sureIn #53, questioned the need for the heap_create changes retained in #35, and Alvaro accepted their removal in #54 before posting the redesigned #56.
Make pg_dump emit ATTACH PARTITION instead of PARTITION OF
24 Apr 2019Alvaro Herreramaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+3 moreAlso in: pg_dump partitions can lead to inconsistent state after restore
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #351 of 1 reviewer saw the final version

Commits only the pg_dump component of #35, with comment revisions, formatting changes, and consolidation of the ATTACH output into one appendPQExpBuffer call. The commit credits David Rowley, whose original patch is #3; thread #40489 contains no later attached patch.

  • Álvaro Herrerasaw the final versiontrailerRevised David's patch and corrected its tests in #11, carried it into #35, and reviewed the final version as committer.

Credits across 3 commits

Author
Alvaro Herrera2
David Rowley2
Reviewer
Alvaro Herrera2
Committer
Alvaro Herrera3