Mar 2022

1 commit
Enforce foreign key correctly during cross-partition updates
20 Mar 2022Alvaro Herreramaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1Also in: Rows removed on child table when updating parent partitioned table.
LLM analysis, 100% suremodified before commitlight changesfrom patchset #701 of 2 reviewers saw the final version

Applying #70 and its final delta #71 to the commit's parent reproduces every changed file except one comment sentence in src/backend/commands/trigger.c. Herrera confirms merging the delta and making wording edits in #72, and the commit credits Amit Langote as author.

  • Masahiko Sawadasaw an earlier versiontrailerIn #19 and #23, Sawada found missing SET NULL/DEFAULT handling and an over-restrictive self-reference case in the early prohibition approach, before the later enforcement redesign.
  • Álvaro Herrerasaw the final versiontrailerHerrera reviewed ABI and trigger-event details, questioned the executor API in #63, prepared the final revisions, and committed the merged patch in #72.

Jan 2022

1 commit
Create foreign key triggers in partitioned tables too
5 Jan 2022Alvaro Herreramaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
LLM analysis, 100% surepart of a posted patchsetmoderate changesfrom patchset #401 of 3 reviewers saw the final version

Commits only the infrastructure patch from the two-patch series in #40, leaving enforcement pending. Besides formatting and assertions, Herrera fixes older-server query aliases in src/bin/pg_dump/pg_dump.c and the version boundary in src/bin/psql/describe.c, as reported in #41.

  • Masahiko Sawadasaw an earlier versiontrailerSawada's detailed infrastructure review in #28 prompted helper inlining, tuple cleanup, comments, and client compatibility fixes, with further pg_dump changes before landing.
  • Arne Rolandsaw an earlier versiontrailerRoland challenged the early series' restriction to foreign-key triggers and supplied a user-trigger example in #11, continuing the design review in #14 before subsequent implementation changes.
  • Alvaro Herrerasaw the final versioncommittercommitted the patch

Credits across 2 commits

Author
Amit Langote2
Reviewer
Alvaro Herreracommitter2
Masahiko Sawada2
Arne Roland1
Reported by
Eduard Català1
Committer
Alvaro Herrera2