Re: MERGE behavior with REPEATABLE READ isolation level

From: Tender Wang <tndrwang(at)gmail(dot)com>
To: Alexander Korotkov <aekorotkov(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>
Subject: Re: MERGE behavior with REPEATABLE READ isolation level
Date: 2026-02-27 12:54:06
Message-ID: CAHewXNk+LhHOUE7EhugnkanEJABp8sg4ViXr4L80LZrQvyuBqg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

Alexander Korotkov <aekorotkov(at)gmail(dot)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

Attachment Content-Type Size
v2-0001-Fix-MERGE-match-do-update-in-RR-isolation-level.patch text/plain 3.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2026-02-27 13:03:06 Re: pageinspect support for SpGiST
Previous Message wenhui qiu 2026-02-27 12:38:41 Re: [PROPOSAL] Doublewrite Buffer as an alternative torn page protection to Full Page Write