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@postgresql.org)
http://pgadmin.postgresql.org/