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: > <https://www.postgresql.org/docs/current/explicit-locking.html> > https://www.postgresql.org/docs/16/explicit-locking.html#LOCKING-TABLES > > https://www.postgresql.org/docs/16/sql-droptrigger.html > <https://www.postgresql.org/docs/current/sql-droptrigger.html>
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. -- Euler Taveira EDB https://www.enterprisedb.com/
