Re: DROP TABLE vs inheritance - Mailing list pgsql-hackers

From Alex Hunsaker
Subject Re: DROP TABLE vs inheritance
Date
Msg-id 34d269d40905121110ye0a3350kb25ea330c3e26334@mail.gmail.com
Whole thread Raw
In response to Re: DROP TABLE vs inheritance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, May 11, 2009 at 21:18, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> However, he can do that anyway via ALTER TABLE, which
> will happily take out AccessExclusiveLock before it checks any
> permissions.  So I'm not seeing the point of risking unsafe behavior
> in LOCK TABLE.

I would rather fix ALTER TABLE to do something similar to test and
test-and-set... From a quick look TRUNCATE also seems to be prone to
this.


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Implementation of GROUPING SETS (T431: Extended grouping capabilities)
Next
From: Alex Hunsaker
Date:
Subject: Re: DROP TABLE vs inheritance