Re: Triggers on TRUNCATE? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Triggers on TRUNCATE?
Date
Msg-id 18597.1090896605@sss.pgh.pa.us
Whole thread Raw
In response to Re: Triggers on TRUNCATE?  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
> Btw, does the right to TRUNCATE come with GRANT DELETE, or must one be a
> superuser to TRUNCATE ?

You have to own the table (or be superuser of course).  This implies the
right to drop its triggers, so TRUNCATE could be seen as dropping
triggers, DELETE, recreate triggers.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: cvsweb upgraded
Next
From: Daniel Baldoni
Date:
Subject: Re: Triggers on TRUNCATE?