Triggers

DROP TRIGGER

Lock mode ACCESS EXCLUSIVE
Risk MEDIUM
Blocks reads, writes, other DDL
pgfence rule drop-trigger 
DROP TRIGGER orders_set_updated_at ON orders;

What this does

Brief but blocks reads as well as writes for the duration, unlike CREATE TRIGGER.

Read more

More in Triggers

Run pgfence on your migrations ← All lock mode patterns