Re: ALTER INDEX not working in 9.5.1?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthew Byrne <mjw(dot)byrne(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ALTER INDEX not working in 9.5.1?
Date: 2016-03-07 06:09:54
Message-ID: 11303.1457330994@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2016-03-07 06:16:27 Re: ALTER INDEX not working in 9.5.1?
Previous Message Andres Freund 2016-03-06 02:18:55 Re: BUG #13844: Logical decoding bug with subxact + row locking