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