On Fri, Jun 7, 2024, at 12:06 PM, Dull Bananas wrote:
On these pages, it should be mentioned that DROP TRIGGER acquires an ACCESS EXCLUSIVE lock:
If I would add such information it would be in the latter. AFAICS the former
provides some examples of SQL commands that take AccessExclusiveLock. If you
search for AccessExclusiveLock into src/backend/commands/* you will notice that
there are more commands that were not mentioned in the Table-Level Locks
section.
Feel free to propose a patch.