Adding a { LOCK ROWS | LOCK KEY INDEX } clause to FK definitions

Edit
ID 6923
Title Adding a { LOCK ROWS | LOCK KEY INDEX } clause to FK definitions
CI (CFBot) Needs rebase! Needs rebase since 1 month. Failing since 2 months.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags Performance SQL Commands
Created 2026-06-22 20:27:53
Last modified 2026-09-09 10:52:52 (1 week ago)
Latest email 2026-06-22 12:50:34 (2 months ago)
Status
PG20-Drafts (2026-03-01 – 2027-02-28): Withdrawn
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version
Authors Matthias van de Meent (mmeent)
Reviewers Become reviewer
Committer
Links
Emails
[WIP] Adding a { LOCK ROWS | LOCK KEY INDEX } clause to FK definitions
First at 2026-06-22 12:50:34 by Matthias van de Meent <boekewurm+postgres at gmail.com>
Latest at 2026-06-22 12:50:34 by Matthias van de Meent <boekewurm+postgres at gmail.com>
Latest attachment (v1-0001-FK-RI-Add-heavy-weight-locking-option-for-RI-chec.patch) at 2026-06-22 12:50:34 from Matthias van de Meent <boekewurm+postgres at gmail.com>
    Attachment (v1-0001-FK-RI-Add-heavy-weight-locking-option-for-RI-chec.patch) at 2026-06-22 12:50:34 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)

Annotations

When Who Mail Annotation
2026-09-09 10:52:52 Matthias van de Meent (mmeent) From Matthias van de Meent <boekewurm+postgres@gmail.com>
at 2026-06-22 12:50:34		 The failures were real failures of the new FK code failing to lock/retain/reject values that got concurrent insertions and deletions on the foreign and primary side. A true implementation of this will need more thoughts on how to make this work in the face of delayed trigger actions.
History
When Who What
2026-09-09 10:52:52 Matthias van de Meent (mmeent) Added annotation "The failures were real failures of the new FK code failing to lock/retain/reject values that [...]" to CAEze2WjPFFfgtWyd8Cfago9fpXd-RKh_Ai6knFdHFztmfXMucw@mail.gmail.com
2026-09-09 10:50:21 Matthias van de Meent (mmeent) Closed in commitfest PG20-Drafts with status: Withdrawn
2026-08-15 04:05:28 CFbot Patch needs rebase
2026-07-28 13:49:52 Matthias van de Meent (mmeent) Moved from CF PG20-1 to CF PG20-Drafts
2026-06-22 20:27:53 Matthias van de Meent (mmeent) Attached mail thread CAEze2WjPFFfgtWyd8Cfago9fpXd-RKh_Ai6knFdHFztmfXMucw@mail.gmail.com
2026-06-22 20:27:53 Matthias van de Meent (mmeent) Created patch record
Edit