Re: Must be owner to truncate?

Stephen Frost wrote:
-- Start of PGP signed section.
> * Jim C. Nasby (decibel@decibel.org) wrote:
> > On Thu, Jul 07, 2005 at 01:48:59PM -0400, Tom Lane wrote:
> > > I don't really agree with the viewpoint that truncate is just a quick
> > > DELETE, and so I do not agree that DELETE permissions should be enough
> > > to let you do a TRUNCATE.
> > 
> > What about adding a truncate permission? I would find it useful, as it
> > seems would others.
> 
> That would be acceptable for me as well.  I'd prefer it just work off
> delete, but as long as I can grant truncate to someone w/o giving them
> ownership rights on the table I'd be happy.

Added to TODO:
* Add TRUNCATE permission  Currently only the owner can TRUNCATE a table because triggers are not  called, and the
tableis locked in exclusive mode.
 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073