BUG #15878: Changing two column types in single request raises error that index already exists.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15878: Changing two column types in single request raises error that index already exists.

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      15878
Logged by:          Andrey Glushkov
Email address:      [hidden email]
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=#

Reply | Threaded
Open this post in threaded view
|

Re: BUG #15878: Changing two column types in single request raises error that index already exists.

Sergei Kornilov
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 this bug or we wait August minor releases.

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

regards, Sergei