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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: greg(dot)amer(at)smxemail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15915: ALTER COLUMN SET DATA TYPE fails with index already exists
Date: 2019-07-18 03:57:03
Message-ID: 28922.1563422223@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2019-07-18 04:25:43 Re: REINDEX CONCURRENTLY causes ALTER TABLE to fail
Previous Message PG Bug reporting form 2019-07-18 03:51:52 BUG #15915: ALTER COLUMN SET DATA TYPE fails with index already exists