Skip site navigation (1) Skip section navigation (2)

Re: Regarding TODO item "%Add a separate TRUNCATE

From: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Regarding TODO item "%Add a separate TRUNCATE
Date: 2006-04-26 18:23:13
Message-ID: 1146075793.19962.21.camel@voyager.truesoftware.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, 2006-04-26 at 13:54 -0400, Tom Lane 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. 

This is actually a very good one I think. Perhaps we shouldn't code and
overkill making things more complex. The only reason I can think of
having a separate TRUNCATE permission is when one could not ROLLBACK a
TRUNCATE. But this is not the case. We can rollback a TRUNCATE :) :)






In response to

pgsql-hackers by date

Next:From: Stephen FrostDate: 2006-04-26 18:23:16
Subject: Re: Regarding TODO item "%Add a separate TRUNCATE permission"
Previous:From: Alvaro HerreraDate: 2006-04-26 18:19:03
Subject: Re: Regarding TODO item "%Add a separate TRUNCATE permission"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group