Stephen Frost <sfrost(at)snowman(dot)net> writes:
> test=> create table a (
> test(> b int primary key
> test(> );
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "a_pkey" for=
> table "a"
> CREATE TABLE
> test=> alter table a rename to c;
> ALTER TABLE
> test=> alter index a_pkey rename to c_pkey;
> ALTER INDEX
Arguably we should forbid ALTER INDEX RENAME on an index that belongs to
a constraint, and make you rename the constraint instead (and have that
implicitly change the index name too).
regards, tom lane