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/