Re: BUG #15915: ALTER COLUMN SET DATA TYPE fails with index already exists - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15915: ALTER COLUMN SET DATA TYPE fails with index already exists
Date
Msg-id 28922.1563422223@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15915: ALTER COLUMN SET DATA TYPE fails with index already exists  (PG Bug reporting form <noreply@postgresql.org>)
List 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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15915: ALTER COLUMN SET DATA TYPE fails with index already exists
Next
From: Michael Paquier
Date:
Subject: Re: REINDEX CONCURRENTLY causes ALTER TABLE to fail