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

Поиск
Список
Период
Сортировка
От Japin Li
Тема Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key
Дата
Msg-id MEYP282MB1669F464FB5DC1EEF5EC80BBB60D9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
On Sat, 12 Mar 2022 at 02:29, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I wrote:
>> (I've not figured out yet why the "cluster" step is required to
>> make this repro work.)
>
> Oh, of course: 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.
>
> The attached seems to do the trick.
>

Fantastic!  Thanks for your detail dig.

--
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17435: "add column if not exists" always adds new FK on the column
Следующее
От: Japin Li
Дата:
Сообщение: Re: BUG #17435: "add column if not exists" always adds new FK on the column