On these pages, it should be mentioned that DROP TRIGGER acquires an ACCESSEXCLUSIVE lock:
<https://stream.boxwatch.ru/docs/current/explicit-locking.html>https://stream.boxwatch.ru/docs/16/explicit-locking.html#LOCKING-TABLES
https://stream.boxwatch.ru/docs/16/sql-droptrigger.html<https://stream.boxwatch.ru/docs/current/sql-droptrigger.html>