Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Must be owner to truncate?
Date
Msg-id 7286.1120792731@sss.pgh.pa.us
Whole thread Raw
In response to Re: Must be owner to truncate?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Must be owner to truncate?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Tree view 
Stephen Frost <sfrost@snowman.net> writes:
> * Andrew - Supernews (andrew+nonews@supernews.com) wrote:
>> It's not MVCC-safe even with the AccessExclusive lock;

> This seems like something which should probably be fixed,

You've missed the point entirely: this *cannot* be fixed, at least not
without giving up the performance advantages that make TRUNCATE
interesting.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Hmmm 8.1 pg_dumpall cannot dump older db's?
Next
From: Tom Lane
Date:
Subject: Re: temp_buffers