ALTER INDEX not working in 9.5.1?

Поиск
Список
Период
Сортировка
От Matthew Byrne
Тема ALTER INDEX not working in 9.5.1?
Дата
Msg-id CAE37PpPAsV8XvTo6jVMTayxzfKRtN5qOgP=ohofY6B18G25fTw@mail.gmail.com
обсуждение исходный текст
Ответы Re: ALTER INDEX not working in 9.5.1?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: ALTER INDEX not working in 9.5.1?  (Venkata Balaji N <nag1010@gmail.com>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: doublem09@googlemail.com
Дата:
Сообщение: BUG #14001: pg_ctl error output empty/faulty
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ALTER INDEX not working in 9.5.1?