Postgres Pro
Downloads
Home   >   mailing lists

Re: lock level for DETACH PARTITION looks sketchy - Mailing list pgsql-hackers

From Robert Haas
Subject Re: lock level for DETACH PARTITION looks sketchy
Date
Msg-id CA+Tgmob7=XEXAABG8HYq5v2-GS5UqNBt5zaRUrESb7jJT+tJEw@mail.gmail.com
Whole thread Raw
In response to Re: lock level for DETACH PARTITION looks sketchy  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: lock level for DETACH PARTITION looks sketchy  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On Thu, Dec 20, 2018 at 3:58 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> I think what prompted the lock to be AccessShareLock for the child rel
> in the first place is the fact that ATExecDropInherit() (ALTER TABLE NO
> INHERIT) uses AccessShare for the *parent* relation.

Seems like apples and oranges, and also maybe not that safe.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: lock level for DETACH PARTITION looks sketchy
Next
From: Robert Haas
Date:
Subject: Re: ATTACH/DETACH PARTITION CONCURRENTLY