Re: ALTER INDEX not working in 9.5.1? - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: ALTER INDEX not working in 9.5.1?
Date
Msg-id CAKFQuwbp0sB-=KPvrivoOHKdSSgZG6Ep8NaN9HY8JEE2qUvqSQ@mail.gmail.com
Whole thread Raw
In response to Re: ALTER INDEX not working in 9.5.1?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: ALTER INDEX not working in 9.5.1?
Next
From: Venkata Balaji N
Date:
Subject: Re: ALTER INDEX not working in 9.5.1?