Re: MERGE loses UPDATE transition rows when moving rows between partitions

From: Tender Wang <tndrwang(at)gmail(dot)com>
To: shihao zhong <zhong950419(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Michael Ries <mries(at)salesforce(dot)com>
Subject: Re: MERGE loses UPDATE transition rows when moving rows between partitions
Date: 2026-11-10 04:45:15
Message-ID: CAHewXNmr8J4btaY+QnB=Oq7HQ78_4JrX2GZ1mCLc6mhCi8PTvg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Shihao,

shihao zhong <zhong950419(at)gmail(dot)com> 于2026年11月10日周二 11:51写道:
> Thanks for the patch. Michael Ries reported the same thing on
> pgsql-bugs [1]. It is a regression from a4f7d33a904, so I think it
> should go back to 15.
>
> v1 no longer applies after 398eb35f001, so v2 is a rebase. Also
> include all the backport versions.
>
> [1] https://postgr.es/m/CAKWDHLgETF86qEW40HcEzMgn5DdmS6yR-nSYwemXF7zFGrU+sQ@mail.gmail.com
>

Thanks for rebasing the patch, preparing the backport versions, and
identifying the commit responsible.

Since this is a regression from a4f7d33a904, I've CC'd Dean, along
with Michael Ries, who also reported the issue.

--
Thanks,
Tender Wang

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2026-11-10 04:55:29 Re: pgsql: Make GetSnapshotData() more resilient on out-of-memory errors
Previous Message David Rowley 2026-11-10 04:32:24 Re: [PATCH] Add memory/disk usage for Function Scan nodes in EXPLAIN