Re: ALTER INDEX not working in 9.5.1?

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

> Matthew Byrne <mjw.byrne@gmail.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
=E2=80=8Bapt.postgresql.org/Ubuntu 14.04=E2=80=8B

=E2=80=8BI didn't do the tablespace query but the two setups and the ALTER =
INDEX
... RENAME worked for me.

David J.=E2=80=8B