Triggers
ALTER TABLE ... ENABLE/DISABLE TRIGGER
ALTER TABLE orders DISABLE TRIGGER orders_set_updated_at;What this does
Same lock mode as CREATE TRIGGER: blocks concurrent writes and other DDL, but not reads.