Re: BUG #15915: ALTER COLUMN SET DATA TYPE fails with index already exists

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #15915: ALTER COLUMN SET DATA TYPE fails with index already exists
Дата
Msg-id 28922.1563422223@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #15915: ALTER COLUMN SET DATA TYPE fails with index already exists  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> When attempting to set the data type on multiple columns in a single sql
> where the columns have indexes, the alter call fails. This previously worked
> on 9.6.6. 

Thanks for the report!  I believe this is the same issue already reported
and fixed at

https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=da1041fc3

At least, your example doesn't fail for me on 9.6 branch tip.

            regards, tom lane



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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15915: ALTER COLUMN SET DATA TYPE fails with index already exists
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: REINDEX CONCURRENTLY causes ALTER TABLE to fail