Re: ALTER INDEX not working in 9.5.1?

On Sun, Mar 6, 2016 at 11:09 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Matthew Byrne <mjw(dot)byrne(at)gmail(dot)com> writes:
> > 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".
>
> [ scratches head... ] Your test case works OK for me. Admittedly,
> I'm checking 9.5-branch-from-a-day-or-two-back rather than exactly
> release 9.5.1; but if we'd broken and then fixed something as basic
> as that, I expect we'd know about it.
>
> Is this on a clean compile of 9.5.1 community sources? Using what
> compiler exactly, on what platform? Maybe you've got something
> like a badly-written event trigger installed?
>

version
PostgreSQL 9.5.1 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
4.8.2-19ubuntu1) 4.8.2, 64-bit
​apt.postgresql.org/Ubuntu 14.04​

​I didn't do the tablespace query but the two setups and the ALTER INDEX
... RENAME worked for me.

David J.​