Re: SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row

From: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
To: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row
Date: 2026-08-25 22:38:35
Message-ID: CAN4CZFO04qRYO1L0xTAp1V_5FFvO=YKp9eUBudvDuEnS_wPftQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thanks for the review!

v3 adds additional test cases, otherwise it is unchanged.

> Does this one deserve a mention on the open items wiki

Probably it should be there, since it's about a pg19 feature.

Attachment Content-Type Size
v3-0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-S.patch application/octet-stream 8.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2026-08-25 22:48:08 Re: tablecmds: fix bug where index rebuild loses replica identity on partitions
Previous Message Tom Lane 2026-08-25 22:33:04 Re: scary patch contest