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 ?
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2004-07-27 00:57:58|
|Subject: Re: cvsweb upgraded|
|Previous:||From: Tom Lane||Date: 2004-07-27 00:37:13|
|Subject: Re: 7.5 backend crash |