Re: BUG #15631: Generated as identity field in a temporary tablewith on commit drop corrupts system catalogs

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #15631: Generated as identity field in a temporary tablewith on commit drop corrupts system catalogs
Дата
Msg-id 20190425005924.GF8552@paquier.xyz
обсуждение исходный текст
Ответ на Re: BUG #15631: Generated as identity field in a temporary tablewith on commit drop corrupts system catalogs  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: BUG #15631: Generated as identity field in a temporary table withon commit drop corrupts system catalogs  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-bugs
Hi Peter,

On Tue, Mar 26, 2019 at 11:45:27AM +0900, Michael Paquier wrote:
> On Wed, Mar 13, 2019 at 10:28:11AM +0100, Peter Eisentraut wrote:
>>                   /* Need CCI between commands */
>> -                 if (lnext(l) != NULL)
>>                       CommandCounterIncrement();
>
> Hmm.  We could actually live with this suggestion, and this impacts
> only CREATE TABLE and ALTER TABLE statements.  I would still add a CCI
> after the internal dependency between the identity sequence and its
> root table is recorded though as there could be other callers of the
> internal sequence API, so a CCI only in utility.c may not be enough.

Is there something else you are considering for this patch?  This
previous suggestion looks fine to live with, at least for me.  Tom,
perhaps you have some extra input on the matter and would prefer a
more restrictive location for the CCI?

>> I think we should also make the implicitly created sequence temporary.
>> Even though the permanent sequence is cleaned up properly, we should
>> avoid having those sequences write to the WAL.
>
> Indeed, sounds good to me.

This is at least v13 material, so I would suggest to discard this item
for now.
--
Michael

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15672: PostgreSQL 11.1/11.2 crashed after dropping a partition table
Следующее
От: Amit Langote
Дата:
Сообщение: Re: BUG #15672: PostgreSQL 11.1/11.2 crashed after dropping apartition table