From: | Matthew Byrne <mjw(dot)byrne(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | ALTER INDEX not working in 9.5.1? |
Date: | 2016-03-05 11:32:21 |
Message-ID: | CAE37PpPAsV8XvTo6jVMTayxzfKRtN5qOgP=ohofY6B18G25fTw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The commands "ALTER INDEX ... RENAME TO..." and "ALTER INDEX ... SET
TABLESPACE ..." seem to work as expected in PostgreSQL 9.4.5 but in 9.5.1
they fail with "ERROR: <index_name> is an index".
I can't find anything in the docs which would explain this.
Sample code:
CREATE TABLE test AS SELECT 1 AS x; --Works fine
CREATE INDEX test_idx ON test(x); --Works fine
ALTER INDEX test_idx RENAME TO other_idx; --Works fine in 9.4.5, throws
"is an index" error in 9.5.1
ALTER INDEX test_idx SET TABLESPACE other_tablespace; --Works fine in
9.4.5, throws "is an index" error in 9.5.1
From | Date | Subject | |
---|---|---|---|
Next Message | doublem09 | 2016-03-05 12:00:21 | BUG #14001: pg_ctl error output empty/faulty |
Previous Message | Andres Freund | 2016-03-05 07:47:28 | Re: BUG #13844: Logical decoding bug with subxact + row locking |