From: Manu <manuelreyesbravo@gmail.com>
To: Ajit Awekar <ajitpostgres@gmail.com>
Cc: Jakub Wartak <jakub.wartak@enterprisedb.com>,
 Etsuro Fujita <etsuro.fujita@gmail.com>,
 Michael Paquier <michael@paquier.xyz>, shihao zhong <zhong950419@gmail.com>,
 Nikita Malakhov <hukutoc@gmail.com>,
 Jehan-Guillaume de Rorthais <jgdr@dalibo.com>,
 pgsql-hackers@lists.postgresql.org, rhaas@postgresql.org
Subject: Re: [(known) BUG] DELETE/UPDATE more than one row in partitioned
 foreign table
Date: Tue, 03 Nov 2026 09:48:08 -0300
Message-ID: <179371008812.1245613.18345043610354071644@gmail.com>
In-Reply-To: 
 <CAER375NOcbQyDGxfRDM0wuRmJx8j5TBmkXtC0QY0j2Doye=HSA@mail.gmail.com>
References: 
 <CAER375NOcbQyDGxfRDM0wuRmJx8j5TBmkXtC0QY0j2Doye=HSA@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/179371008812.1245613.18345043610354071644%40gmail.com>
Precedence: bulk

Hi Ajit,

On Tue, Nov 3, 2026 at 6:59 AM Ajit Awekar <ajitpostgres@gmail.com>
wrote:
>   I added regression tests for 1 and 2.  Manu's case_i_whole_row.sql
>   (i1-i8) runs without errors on v5, with the same results as  master.

Confirmed on master 3ba886b35a2 with cassert: v5 builds without
warnings, make check and postgres_fdw's check pass, and
case_i_whole_row returns the same rows as master; only the plans
differ.  Through a single foreign table the duplicate-ctid UPDATEs and
DELETEs now hit the right rows (7 of 7, master 0 of 7), and the
chained case is unchanged, as the docs now say.

I've set the entry to Ready for Committer.

Regards,
Manu