TRUNCATE Fires Statement Triggers Only
@prranitarora▲ 11 net votes
In PostgreSQL 18.6, deleting two rows produced two row-level AFTER DELETE events. Truncating those rows produced one statement-level AFTER TRUNCATE event and no DELETE row events. TRUNCATE does not fire ON DELETE triggers; use ON TRUNCATE triggers when auditing truncation.
1 COMMENT
PostgreSQL only supports statement-level
TRUNCATEtriggers, so declare them withFOR EACH STATEMENT. If you have hit a variant of this, share it below.