[BUG] DELETE/UPDATE more than one row in partitioned foreign table

Edit
ID 6770
Title [BUG] DELETE/UPDATE more than one row in partitioned foreign table
CI (CFBot) Summary
Stats (from CFBot) Patch version: v2, Patch count: 1, First patch: +778−249, All patches: +778−249
Tags Bugfix Extensions
Created 2026-05-14 15:05:17
Last modified 2026-09-07 03:16:03 (1 week ago)
Latest email 2026-09-16 13:15:44 (yesterday)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version 20
Authors Nikita Malakhov (nmalakh), ajitpostgres awekar (ajit.awekar)
Reviewers Become reviewer
Committer
Links
Emails
[(known) BUG] DELETE/UPDATE more than one row in partitioned foreign table
First at 2025-07-18 15:53:14 by Jehan-Guillaume de Rorthais <jgdr at dalibo.com>
Latest at 2026-09-16 13:15:44 by Manuel Reyes Bravo <manuelreyesbravo at gmail.com>
Latest attachment (run_cases.sh) at 2026-09-16 13:15:44 from Manuel Reyes Bravo <manuelreyesbravo at gmail.com>
    Attachment (run_cases.sh) at 2026-09-16 13:15:44 from Manuel Reyes Bravo <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (v2-0001-postgres_fdw-Disambiguate-row-identity-by-remote-tableoid.patch) at 2026-09-10 12:21:16 from Ajit Awekar <ajitpostgres at gmail.com> (Patch: No)
    Attachment (0001-postgres_fdw-Disambiguate-row-identity-by-remote-tab.patch) at 2026-08-27 09:20:48 from Ajit Awekar <ajitpostgres at gmail.com> (Patch: No)
    Attachment (v4-0001-copy-and-remote-tableoid-param.patch) at 2026-07-09 14:03:58 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (v3-0001-postgres_fdw-Disallow-UPDATE-DELETE-in-problematic-c.patch) at 2026-06-05 11:59:17 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (postgres_fdw-disallow-upddel-in-problematic-cases-v2.patch) at 2026-06-01 10:44:34 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (v3-0003-teach-fdw-use-remote-tableoid.patch) at 2026-05-14 17:22:55 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (v2-0002-core-remote-tableoid-param.patch) at 2026-05-14 15:05:41 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (v1-0003-fdw-del-upd-using-tableoid.patch) at 2026-04-21 11:34:28 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (postgres_fdw-disallow-upddel-in-problematic-cases-wip.patch) at 2025-07-23 10:38:19 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Test-exposing-bug-when-foreign-table-points-to-a-.patch) at 2025-07-18 15:53:14 from Jehan-Guillaume de Rorthais <jgdr at dalibo.com> (Patch: Yes)

Annotations

When Who Mail Annotation
2026-09-07 03:16:03 shihao zhong (zhong950419) From shihao zhong <zhong950419@gmail.com>
at 2026-09-07 03:07:12		 Duplicate of #6770; author merged there.
History
When Who What
2026-09-07 03:16:03 shihao zhong (zhong950419) Added annotation "Duplicate of #6770; author merged there." to CAGRkXqQ57VGjTWFYPsj7HUqHZTJD7ecAx-m0P4st4Ae1HbqcfA@mail.gmail.com
2026-09-07 03:05:00 shihao zhong (zhong950419) Changed authors to Nikita Malakhov (nmalakh), ajitpostgres awekar (ajit.awekar)
2026-09-07 03:05:00 shihao zhong (zhong950419) Changed targetversion to 20
2026-08-27 09:40:33 CFbot Patch does not need rebase anymore
2026-08-20 02:18:26 CFbot Patch needs rebase
2026-08-01 00:00:10 CFbot Moved from CF PG20-1 to CF PG20-2
2026-07-09 14:42:32 CFbot Patch does not need rebase anymore
2026-06-25 00:52:27 CFbot Patch needs rebase
2026-06-05 12:01:41 CFbot Patch does not need rebase anymore
2026-06-01 11:04:23 CFbot Patch needs rebase
2026-05-14 15:05:17 Nikita Malakhov (nmalakh) Attached mail thread 20250718175314.4513c00a@karst
2026-05-14 15:05:17 Nikita Malakhov (nmalakh) Created patch record
Edit