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

Edit
ID 7213
Title SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row
CI (CFBot) Summary
Stats (from CFBot) Patch version: v3, Patch count: 1, First patch: +157−1, All patches: +157−1
Tags Bugfix
Created 2026-08-28 21:02:42
Last modified 2026-08-28 21:02:42 (1 hour ago)
Latest email 2026-08-26 12:58:45 (2 days ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
Target version 19
Authors Zsolt Parragi (zsolt.parragi)
Reviewers Become reviewer
Committer
Links
Emails
SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row
First at 2026-08-19 11:33:01 by Zsolt Parragi <zsolt.parragi at percona.com>
Latest at 2026-08-26 12:58:45 by Andrey Borodin <x4mmm at yandex-team.ru>
Latest attachment (v3-0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-S.patch) at 2026-08-25 22:38:35 from Zsolt Parragi <zsolt.parragi at percona.com>
    Attachment (v3-0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-S.patch) at 2026-08-25 22:38:35 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)
    Attachment (v2-0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-S.patch) at 2026-08-19 19:32:48 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)
    Attachment (0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-SELE.patch) at 2026-08-19 11:33:01 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)
History
When Who What
2026-08-28 21:02:42 Zsolt Parragi (zsolt.parragi) Attached mail thread CAN4CZFM1GkHJkpMeo4G5rxtacVsfeKCJYiik9E9AKX1E9VYQ1w@mail.gmail.com
2026-08-28 21:02:42 Zsolt Parragi (zsolt.parragi) Created patch record
Edit