Fix firing of RI triggers during cross-partition updates of partitioned tables

Edit
ID 2877
Title Fix firing of RI triggers during cross-partition updates of partitioned tables
Topic Bug Fixes
Created 2020-12-14 13:03:57
Last modified 2022-03-20 17:58:25 (2 years, 7 months ago)
Latest email 2022-03-22 01:18:05 (2 years, 7 months ago)
Status
2022-03: Committed
2022-01: Moved to next CF
2021-11: Moved to next CF
2021-09: Moved to next CF
2021-07: Moved to next CF
2021-03: Moved to next CF
2021-01: Moved to next CF
Target version
Authors Amit Langote (amitlan)
Reviewers Masahiko Sawada (masahikosawada)Become reviewer
Committer Álvaro Herrera (alvherre)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2877
git checkout commitfest/cf/2877
Emails
a misbehavior of partition row movement (?)
First at 2020-10-02 11:56:32 by Amit Langote <amitlangote09 at gmail.com>
Latest at 2022-03-22 01:18:05 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v16_delta.diff) at 2022-03-20 02:58:39 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v16_delta.diff) at 2022-03-20 02:58:39 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Enforce-foreign-key-correctly-during-cross-parti.patch) at 2022-03-19 20:13:43 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v15-0001-Enforce-foreign-key-correctly-during-cross-parti.patch) at 2022-03-18 16:38:33 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (delta-over-v13.diff.txt) at 2022-01-19 07:59:00 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (delta-over-v13.diff) at 2022-01-19 07:13:13 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Enforce-foreign-key-correctly-during-cross-parti.patch) at 2022-01-18 22:29:25 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (14_v12-0002-Enforce-foreign-key-correctly-during-cross-partition.patch.txt) at 2022-01-17 11:40:54 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Enforce-foreign-key-correctly-during-cross-parti.patch) at 2022-01-13 03:19:27 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (14_0001-Create-foreign-key-triggers-in-partitioned-tables-to.patch) at 2022-01-11 08:08:59 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Enforce-foreign-key-correctly-during-cross-parti.patch) at 2022-01-05 22:27:45 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v11-0002-Enforce-foreign-key-correctly-during-cross-parti.patch) at 2021-12-20 13:10:30 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Create-foreign-key-triggers-in-partitioned-table.patch) at 2021-10-14 09:00:51 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Create-foreign-key-triggers-in-partitioned-tables.patch) at 2021-09-20 06:32:23 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Create-foreign-key-triggers-in-partitioned-tables.patch) at 2021-09-10 14:03:36 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Create-foreign-key-triggers-in-partitioned-tables.patch) at 2021-04-02 13:09:10 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Enforce-foreign-key-correctly-during-cross-partit.patch) at 2021-03-23 09:27:38 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Create-foreign-key-triggers-in-partitioned-tables.patch) at 2021-02-26 07:29:49 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Create-foreign-key-triggers-in-partitioned-tables.patch) at 2021-02-19 03:09:40 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (prevent-row-movement-on-pk-table.patch) at 2021-02-15 13:37:17 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Create-foreign-key-triggers-in-partitioned-tables.patch) at 2021-01-25 09:06:31 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Create-foreign-key-triggers-in-partitioned-tables.patch) at 2020-12-22 07:57:30 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Create-foreign-key-triggers-in-partitioned-tables.patch) at 2020-11-20 11:55:21 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (prevent-row-movement-on-delete-cascade.patch) at 2020-10-02 11:56:32 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
History
When Who What
2022-03-20 17:58:25 Álvaro Herrera (alvherre) Closed in commitfest 2022-03 with status: Committed
2022-02-02 16:19:08 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-04 23:39:10 Álvaro Herrera (alvherre) Added alvherre as committer
2021-12-02 11:27:01 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2021-11 with status: Moved to next CF
2021-10-04 20:14:21 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-09-20 06:32:47 Amit Langote (amitlan) New status: Needs review
2021-08-03 02:37:58 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2021-08-03 02:36:45 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-08-03 02:36:41 Masahiko Sawada (masahikosawada) New status: Needs review
2021-07-13 11:25:23 Ibrar Ahmed (ibrar) New status: Waiting on Author
2021-04-08 15:38:04 David Steele (dsteele) Closed in commitfest 2021-03 with status: Moved to next CF
2021-04-07 12:55:30 Amit Langote (amitlan) Changed topic to Bug Fixes
2021-02-15 07:12:08 Masahiko Sawada (masahikosawada) Added masahikosawada as reviewer
2021-02-01 12:22:10 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-14 13:04:10 Amit Langote (amitlan) Changed authors to Amit Langote (amitlan)
2020-12-14 13:03:57 Amit Langote (amitlan) Attached mail thread CA+HiwqFvkBCmfwkQX_yBqv2Wz8ugUGiBDxum8=WvVbfU1TXaNg@mail.gmail.com
2020-12-14 13:03:57 Amit Langote (amitlan) Created patch record
Edit