ALTER INDEX not working in 9.5.1?

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

Responses

Browse pgsql-bugs by date

  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