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

Edit

Title

Topic

Bug Fixes

Created

2020-12-14 13:03:57

Last modified

2022-03-20 17:58:25 (2 years, 1 month ago)

Latest email

2022-03-22 01:18:05 (2 years 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

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