* Stephen Frost ([EMAIL PROTECTED]) wrote: > * Alvaro Herrera ([EMAIL PROTECTED]) wrote: > > Stephen Frost wrote: > > > > > > The question that really ought to be answered before doing any of this > > > > is why DELETE privilege shouldn't be sufficient to allow TRUNCATE. > > > > > > 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.
Let me qualify that- in cases where there aren't row-level triggers or
other things which would prevent it from being possible anyway.
Thanks,
Stephen
signature.asc
Description: Digital signature
