BUG #15871: Regression in 11.4 altering type on column with an index
От | PG Bug reporting form |
---|---|
Тема | BUG #15871: Regression in 11.4 altering type on column with an index |
Дата | |
Msg-id | 15871-d05340216f10eee4@postgresql.org обсуждение исходный текст |
Ответы |
BUG #15871: Regression in 11.4 altering type on column with an index
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15871 Logged by: Tom Dunstan Email address: pgsql@tomd.cc PostgreSQL version: 11.4 Operating system: Linux x86_64 (Alpine 3.9) Description: This worked up to 11.3: test=# CREATE TABLE foo (ts1 TIMESTAMP NOT NULL, ts2 TIMESTAMP NOT NULL); CREATE TABLE test=# CREATE INDEX foo_ts1_idx ON foo (ts1); CREATE INDEX test=# CREATE INDEX foo_ts2_idx ON foo (ts2); CREATE INDEX test=# ALTER TABLE FOO ALTER ts1 TYPE TIMESTAMP WITH TIME ZONE, ALTER ts2 TYPE TIMESTAMP WITH TIME ZONE; ERROR: 42P07: relation "foo_ts1_idx" already exists LOCATION: index_create, index.c:877 Necessary condition seems to be: - Multiple columns altered in the same statement - Both altered columns have an index Altering in separate statements, or not having one of the indexes doesn't trigger it. May be related to this item mentioned in the 11.4 release notes: "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint (Tom Lane)"
В списке pgsql-bugs по дате отправления: