Re: Regarding TODO item "%Add a separate TRUNCATE permission" - Mailing list pgsql-hackers

Stephen Frost wrote:
> * Alvaro Herrera (alvherre@commandprompt.com) wrote:
> > Stephen Frost wrote:
> > > TRUNCATE doesn't follow MVCC...
> > 
> > We can certainly talk about fixing that.  (And CLUSTER at the same time,
> > I think.)
> 
> The issue is that it seems to be intractable to retain MVCC-ness *and*
> provide the performance savings TRUNCATE gives.  If you can solve that
> problem then we could get rid of TRUNCATE and implement
> DELETE-without-WHERE using that magic.

Doh, sorry, I was thinking in CLUSTER :-(

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support