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

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: Tender Wang <tndrwang(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: MERGE loses UPDATE transition rows when moving rows between partitions
Date: 2026-11-10 03:51:18
Message-ID: CAGRkXqR338ryeDygg1uZ3P+T-UpMt0D-JMFf3v7TO6gJUQbEyg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Tender,

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,
Shihao

Attachment Content-Type Size
v2-0001-Fix-transition-tables-for-cross-partition-MERGE-u.patch application/octet-stream 7.2 KB
nocfbot-v2-REL_17_19-0001-Fix-transition-tables-for-cross-partition-MERGE-upda.patch application/octet-stream 7.2 KB
nocfbot-v2-REL_15_16-0001-Fix-transition-tables-for-cross-partition-MERGE-upda.patch application/octet-stream 7.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shihao zhong 2026-11-10 03:56:46 Re: UNDO with FILEOPS, and the FLUX table AM
Previous Message Sho Ito 2026-11-10 03:41:46 Re: [PATCH] psql: Complete INDEX after REPACK USING