Re: [(known) BUG] DELETE/UPDATE more than one row in partitioned foreign table
Nikita Malakhov <hukutoc@gmail.com>
From: Nikita Malakhov <hukutoc@gmail.com>
To: Etsuro Fujita <etsuro.fujita@gmail.com>
Cc: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>,
pgsql-hackers@lists.postgresql.org
Date: 2026-05-14T15:05:41Z
Lists: pgsql-hackers
Attachments
- v2-0002-core-remote-tableoid-param.patch (application/octet-stream) patch v2-0002
- v2-0001-copy-slot-tuple-natts.patch (application/octet-stream) patch v2-0001
- v2-0003-teach-fdw-use-remote-tableoid.patch (application/octet-stream) patch v2-0003
Hi hackers! I've rebased the patch set and created patch in current commitfest. Reviewers are welcome! Current Postgres copy slot/tuple mechanics supports only the case where source and destination slot/tuple have an equal number of attributes. To support additional remote OID attribute I've extended these functions to be able to work when source and destination differ. The second patch - core-remote-tableoid-param - introduces remote table OID and passes it through the executor to be used by the FDW engine. The third patch teaches FDW engine to use this remote table OID in UPDATE and DELETE queries. CF entry: https://commitfest.postgresql.org/patch/6770/ -- Regards, Nikita Malakhov Postgres Professional The Russian Postgres Company https://postgrespro.ru/