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, 8 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