Re: BUG #16249: Partition pruning blocks on exclusively locked table partition

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16249: Partition pruning blocks on exclusively locked table partition
Дата
Msg-id 29415.1581103064@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #16249: Partition pruning blocks on exclusively locked table partition  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16249: Partition pruning blocks on exclusively locked table partition  (0010203112132233 <boekewurm@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
PG Bug reporting form <noreply@postgresql.org> writes:
> In my humble opinion, this query should not be blocked during planning, as
> the partition can be pruned directly from the plan with the partition
> information that is available from the parent table: Partition information
> can be updated  when the partition is locked, but through the parent
> partitioned table. 

This case has been improved in PG v12.  It is operating as designed in
v11, however.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16248: ALTER SYSTEM quoting of values does not work as expected
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: FK violation in partitioned table after truncating a referencedpartition