On E, 2004-07-26 at 17:59, Tom Lane wrote:
> Daniel Baldoni <pgsql(at)lcds(dot)com(dot)au> 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