Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key
Дата
Msg-id Yi7z7v5vY6ArWBok@paquier.xyz
обсуждение исходный текст
Ответ на Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-bugs
On Fri, Mar 11, 2022 at 01:29:05PM -0500, Tom Lane wrote:
> Oh, of course:

Thanks for dropping by the thread.  I was planning to bisect that
but with the CF things have gone out of hand.

> the failure only occurs if we think the index is clustered
> or a replica-identity index; else we don't store a request to rebuild it.

Yes, I think that what you did in 369398e to tweak
get_constraint_name() is the right fix, or we'd finish by creating
more index rebuild requests than necessary when going through the
inheritance tree of these tables.
--
Michael

Вложения

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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Reconnect a single connection used by multiple threads in embedded SQL in C application causes error.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key