Обсуждение: BUG #15878: Changing two column types in single request raises error that index already exists.

The following bug has been logged on the website:

Bug reference:      15878
Logged by:          Andrey Glushkov
Email address:      aglushkov@shakuro.com
PostgreSQL version: 11.4
Operating system:   Ubuntu 18.04.2 LTS
Description:

psql -U postgres
psql (11.4 (Ubuntu 11.4-1.pgdg18.04+1))
Type "help" for help.

postgres=# CREATE DATABASE test_database;
CREATE DATABASE
postgres=# \c test_database
You are now connected to database "test_database" as user "postgres".
test_database=# 
test_database=# CREATE TABLE comments(
test_database(#   weight integer,
test_database(#   is_question boolean
test_database(# );
CREATE TABLE
test_database=# 
test_database=# CREATE INDEX index_comments_on_weight ON comments USING
btree (weight);
CREATE INDEX
test_database=# CREATE INDEX index_comments_on_is_question ON comments USING
btree (is_question);
CREATE INDEX
test_database=# 
test_database=# \set VERBOSITY verbose
test_database=# 
test_database=# ALTER TABLE "comments"
test_database-#   ALTER COLUMN "weight" TYPE integer,
test_database-#   ALTER COLUMN "is_question" TYPE boolean;
ERROR:  42P07: relation "index_comments_on_weight" already exists
LOCATION:  index_create, index.c:877
test_database=#

Hello

Unfortunally this is regression in 11.4, you are right.
This is bug is already fixed in report #15865 [1], but not yet released. Not sure if an earlier release is planned for
thisbug or we wait August minor releases.
 

https://www.postgresql.org/message-id/flat/15865-17940eacc8f8b081%40postgresql.org

regards, Sergei