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 20190213023817.GD5746@paquier.xyz
обсуждение исходный текст
Ответ на Re: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #15631: Generated as identity field in a temporary tablewith on commit drop corrupts system catalogs  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-bugs
On Tue, Feb 12, 2019 at 09:27:50AM -0500, Tom Lane wrote:
> Hm, I'd be more inclined to find where the sequence creation is happening
> and add a CCI at the end, because that comports better with the general
> plan for inserting CCIs.  There may be other issues of this same sort with
> doing-X-just-after-identity-sequence-creation if you don't fix it that
> way.

Agreed.  I don't think that it is the correct logic to put an
after-the-fact CCI just before executing any drop or truncate actions.
It should happen after the creation of the new object so as it becomes
correctly visible within the transaction.
--
Michael

Вложения

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

Предыдущее
От: "Saul, Jean Paolo"
Дата:
Сообщение: Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes
Следующее
От: Amit Langote
Дата:
Сообщение: Re: BUG #15623: Inconsistent use of default for updatable view