Possible bug in ALTER TABLE RENAME COLUMN (PostgreSQL 7.1.3)

Hi,

During testing of new revision control code in pgAdmin II, I've found that
renaming an indexed column in a table does not automatically update the
index column name in pg_attribute. pg_get_indexdef does return the correct
definition however:

helpdesk=# CREATE TABLE sheep (cow text);
CREATE
helpdesk=# CREATE INDEX goat ON sheep (cow);
CREATE
helpdesk=# \d goat
Index "goat"
Attribute | Type
-----------+------
cow | text
btree

(END)
helpdesk=# ALTER TABLE sheep RENAME cow TO chicken;
ALTER
helpdesk=# \d sheep
Table "sheep"
Attribute | Type | Modifier
-----------+------+----------
chicken | text |
Index: goat

(END)
helpdesk=# \d goat
Index "goat"
Attribute | Type
-----------+------
cow | text
btree

(END)
helpdesk=# SELECT pg_get_indexdef((SELECT oid FROM pg_class WHERE relname =
'goat'));
pg_get_indexdef
-----------------------------------------------------------
CREATE INDEX goat ON sheep USING btree (chicken text_ops)
(1 row)

(END)

(Please CC any replies as I'm not on this list)

Regards, Dave.

--
Dave Page (dpage(at)postgresql(dot)org)
http://pgadmin.postgresql.org/