From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | aglushkov(at)shakuro(dot)com |
Subject: | BUG #15878: Changing two column types in single request raises error that index already exists. |
Date: | 2019-06-27 07:10:12 |
Message-ID: | 15878-376cf74cd44eac2b@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15878
Logged by: Andrey Glushkov
Email address: aglushkov(at)shakuro(dot)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=#
From | Date | Subject | |
---|---|---|---|
Next Message | Sergei Kornilov | 2019-06-27 07:48:41 | Re: BUG #15878: Changing two column types in single request raises error that index already exists. |
Previous Message | PG Bug reporting form | 2019-06-27 02:46:54 | BUG #15877: Cannot CREATE EXTENSION for postgis 2.4 because of missing gdal23-libs ldconfig path |