On E, 2004-07-26 at 17:59, Tom Lane wrote: > 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.
Maybe he was after statement level triggers ? We don't support them, and one also can't define a RULE for TRUNCATE - so the advice would be to use TRUNCATE very sparingly ;) Btw, does the right to TRUNCATE come with GRANT DELETE, or must one be a superuser to TRUNCATE ? --------------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]