pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Manu <manuelreyesbravo@gmail.com>
To: Ajit Awekar <ajitpostgres@gmail.com>
Cc: Jakub Wartak <jakub.wartak@enterprisedb.com>
Cc: Etsuro Fujita <etsuro.fujita@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: shihao zhong <zhong950419@gmail.com>
Cc: Nikita Malakhov <hukutoc@gmail.com>
Cc: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Cc: pgsql-hackers@lists.postgresql.org
Cc: 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> (raw)
In-Reply-To: <CAER375NOcbQyDGxfRDM0wuRmJx8j5TBmkXtC0QY0j2Doye=HSA@mail.gmail.com>
References: <CAER375NOcbQyDGxfRDM0wuRmJx8j5TBmkXtC0QY0j2Doye=HSA@mail.gmail.com>

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






view thread (37+ messages)

Message-ID: <179371008812.1245613.18345043610354071644@gmail.com>
Permalink:  ../179371008812.1245613.18345043610354071644@gmail.com/
Also on:    postgresql.org/message-id/179371008812.1245613.18345043610354071644@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: manuelreyesbravo@gmail.com, ajitpostgres@gmail.com, jakub.wartak@enterprisedb.com, etsuro.fujita@gmail.com, michael@paquier.xyz, zhong950419@gmail.com, hukutoc@gmail.com, 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
  In-Reply-To: <179371008812.1245613.18345043610354071644@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox