Re: lock level for DETACH PARTITION looks sketchy

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: lock level for DETACH PARTITION looks sketchy
Дата
Msg-id CA+Tgmob7=XEXAABG8HYq5v2-GS5UqNBt5zaRUrESb7jJT+tJEw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: lock level for DETACH PARTITION looks sketchy  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: lock level for DETACH PARTITION looks sketchy  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: lock level for DETACH PARTITION looks sketchy
Следующее
От: Robert Haas
Дата:
Сообщение: Re: ATTACH/DETACH PARTITION CONCURRENTLY