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

Edit
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 (6 months, 1 week ago)
Latest email 2022-03-22 01:18:05 (6 months, 1 week 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