Re: Must be owner to truncate? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Must be owner to truncate?
Date
Msg-id 42CDE38B.4070300@familyhealth.com.au
Whole thread Raw
In response to Re: Must be owner to truncate?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Must be owner to truncate?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
> There are other reasons for restricting it:
>  * truncate takes a much stronger lock than a plain delete does.
>  * truncate is not MVCC-safe.
> 
> 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.

Ah.  I didn't realise that 2nd point.  I don't care so much about the 
stronger lock in my application.

Chris



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Must be owner to truncate?
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Pg_autovacuum on FreeBSD