Re: [BUGS] renaming index leaves database inconsistent

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Poole <rp(at)gxn(dot)net>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] renaming index leaves database inconsistent
Date: 1999-12-07 01:59:13
Message-ID: 20791.944531953@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Richard Poole <rp(at)gxn(dot)net> writes:
> rptest=> create table foo(i int);
> rptest=> create index foo_index on foo(i);
> rptest=> alter table foo_index rename to new_foo_index;
> ERROR: TypeRename: type foo_index not defined

In current sources I get
ERROR: foo_index is an index relation
and no damage has been done. Seems like it ought to be possible to
rename an index, however, so I'd say this is a stopgap not a solution.

regards, tom lane

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 1999-12-07 02:18:41 Re: [BUGS] Too large tuples corrupting tables
Previous Message Richard Poole 1999-12-07 00:21:25 renaming index leaves database inconsistent