DROP TRIGGER lock

On these pages, it should be mentioned that DROP TRIGGER acquires an ACCESS EXCLUSIVE lock: https://www.postgresql.org/docs/16/explicit-locking.html#LOCKING-TABLES https://www.postgresql.org/docs/16/sql-droptrigger.html

Re: Transition relation clarification

: > On Mon, Jan 1, 2024 at 9:35 AM Dull Bananas > wrote: > >> The docs should mention that transition relations aren't automatically >> made available in functions called by the trigger function. This unknown >> behavior caused a lot of frustration for me. > >

Transition relation clarification

The docs should mention that transition relations aren't automatically made available in functions called by the trigger function. This unknown behavior caused a lot of frustration for me.