Re: Regarding TODO item "%Add a separate TRUNCATE permission"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, Gevik Babakhani <pgdev(at)xs4all(dot)nl>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Regarding TODO item "%Add a separate TRUNCATE permission"
Date: 2006-04-26 19:04:51
Message-ID: 20302.1146078291@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Currently only the owner can TRUNCATE a table because triggers are not
> called, and the table is locked in exclusive mode.

Doh. Of course the point about not calling ON DELETE triggers is why
this has to be considered a special privilege.

Never mind me, I've still got a bad head-cold :-(

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-04-26 19:12:46 Re: [HACKERS] Enhanced containment selectivity function
Previous Message Alvaro Herrera 2006-04-26 18:52:40 Re: Regarding TODO item "%Add a separate TRUNCATE permission"