PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15878
PG Version11.4
OSUbuntu 18.04.2 LTS
Opened2019-06-27 07:10:12+00
Reported byAndrey Glushkov
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15878
Logged by:          Andrey Glushkov
Email address:      (redacted)
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=#

Messages

DateAuthorSubject
2019-06-27 07:10:12+00PG Bug reporting formBUG #15878: Changing two column types in single request raises error that index already exists.
2019-06-27 07:48:41+00Sergei KornilovRe: BUG #15878: Changing two column types in single request raises error that index already exists.