Daniel Baldoni <[EMAIL PROTECTED]> writes: > Forgive this if it's totally "out there" but I was wondering why there's no > support for triggers on a TRUNCATE operation.
Because the entire point of TRUNCATE is not to scan the table contents.
If you want to fire triggers, just use "DELETE FROM foo".
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
