Re: Triggers on TRUNCATE?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Daniel Baldoni <pgsql(at)lcds(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Triggers on TRUNCATE?
Date: 2004-07-27 02:50:05
Message-ID: 18597.1090896605@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hannu Krosing <hannu(at)tm(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Baldoni 2004-07-27 03:27:06 Re: Triggers on TRUNCATE?
Previous Message pgsql 2004-07-27 02:06:28 Re: Binary Cursors, and the COPY command