Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)
Дата
Msg-id 20191031090734.GH2530@paquier.xyz
обсуждение исходный текст
Ответ на Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
On Mon, Oct 28, 2019 at 10:56:33PM -0500, Justin Pryzby wrote:
> I suppose it should something other than partition(ed), since partitions can be
> partitioned, too...
>
>       Attaching a partition acquires a <literal>SHARE UPDATE EXCLUSIVE</literal>
>       lock on the parent table, in addition to
>       <literal>ACCESS EXCLUSIVE</literal> locks on the child table and the
>       <literal>DEFAULT</literal> partition (if any).

In this context, "on the child table" sounds a bit confusing?  Would
it make more sense to say the "on the table to be attached" instead?
--
Michael

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [PATCH] Do not use StdRdOptions in Access Methods
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: Getting psql to redisplay command after \e