Allow reads to proceed during FK/trigger drops by reducing relation-level lock from AccessExclusive to ShareRowExclusive

Edit
ID 6124
Title Allow reads to proceed during FK/trigger drops by reducing relation-level lock from AccessExclusive to ShareRowExclusive
CI (CFBot) Summary
Stats (from CFBot) Patch version: v2, Patch count: 1, First patch: +285−10, All patches: +285−10
Topic Server Features
Tags My First Patch
Created 2025-10-13 12:53:52
Last modified 2025-10-13 12:54:23 (2 hours ago)
Latest email 2025-10-09 11:20:32 (4 days ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
Target version 19
Authors Shayon Mukherjee (shayonj)
Reviewers Become reviewer
Committer
Links Git
Emails
Proposal for discussions: Allow reads to proceed during FK/trigger drops by reducing relation-level lock from AccessExclusive to ShareRowExclusive
First at 2025-10-07 16:54:07 by Shayon Mukherjee <shayonj at gmail.com>
Latest at 2025-10-09 11:20:32 by Shayon Mukherjee <shayonj at gmail.com>
Latest attachment (v2-0001-Reduce-lock-level-for-FK-trigger-drops-to-allow-c.patch) at 2025-10-09 11:20:32 from Shayon Mukherjee <shayonj at gmail.com>
    Attachment (v2-0001-Reduce-lock-level-for-FK-trigger-drops-to-allow-c.patch) at 2025-10-09 11:20:32 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Reduce-lock-level-for-FK-trigger-drops-to-allow-c.patch) at 2025-10-08 21:16:12 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Allow-reads-to-proceed-during-FK-trigger-drops-by.patch) at 2025-10-07 16:54:07 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)
History
When Who What
2025-10-13 12:54:23 Shayon Mukherjee (shayonj) Changed name to Allow reads to proceed during FK/trigger drops by reducing relation-level lock from AccessExclusive to ShareRowExclusive
2025-10-13 12:53:52 Shayon Mukherjee (shayonj) Attached mail thread CANqtF-q3G4pYj1e8fL7CW=UXjktn+Ek_q3tSC05i+zKWtv8RSA@mail.gmail.com
2025-10-13 12:53:52 Shayon Mukherjee (shayonj) Created patch record
Edit