Tom Lane wrote: > Stephen Frost <[EMAIL PROTECTED]> writes: > > we need > > to redesign the permission system to allow for more permission bits > > because otherwise we'll run out soon. > > Only if we keep inventing separate privileges for things as specific > as TRUNCATE. I was just about to raise this point as a possible reason > why not to invent a separate TRUNCATE bit. (There are other problems, > eg both 't' and 'T' letters are already taken.) > > The question that really ought to be answered before doing any of this > is why DELETE privilege shouldn't be sufficient to allow TRUNCATE.
TODO has: * %Add a separate TRUNCATE permission Currently only the owner can TRUNCATE a table because triggers are not called, and the table is locked in exclusive mode. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings