Re: MERGE behavior with REPEATABLE READ isolation level

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Tender Wang <tndrwang(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-03-01 22:32:12
Message-ID: CAPpHfdvAnMaWh4BKPYtZYZsq6UutssLStYA8VQLLKUhC5gF6gA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Feb 27, 2026 at 2:54 PM Tender Wang <tndrwang(at)gmail(dot)com> wrote:
> 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.

Looks good to me. I'll push it if no objections.

------
Regards,
Alexander Korotkov
Supabase

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexandre Felipe 2026-03-01 22:32:53 Re: index prefetching
Previous Message Jelte Fennema-Nio 2026-03-01 22:16:38 Re: RFC: adding pytest as a supported test framework