Re: [BUGS] renaming index leaves database inconsistent
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Poole <rp@gxn.net>
Cc: pgsql-bugs@postgreSQL.org
Date: 1999-12-07T01:59:13Z
Lists: pgsql-bugs
Richard Poole <rp@gxn.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