Horton

Re: MERGE behavior with REPEATABLE READ isolation level

Tender Wang <tndrwang@gmail.com>

View thread View on postgr.es
From: Tender Wang <tndrwang@gmail.com>
To: Alexander Korotkov <aekorotkov@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2026-02-27T12:54:06Z
Lists: pgsql-hackers

Attachments

Hi all,

Alexander Korotkov <aekorotkov@gmail.com> 于2026年2月27日周五 01:03写道：
> Thank you for the confirmation and for the patch.  Regarding the test
> case, can we handle this without introducing a new .spec file?  I
> think we can add 1-2 permutations to merge-update.spec.  Even existing
> step should work, you only need one new which begins transaction in RR
> isolation mode.

Done
Please see the v2 patch.

-- 
Thanks,
Tender Wang

Commits

  1. Fix handling of updated tuples in the MERGE statement