Re: [BUGS] Possible bug in ALTER TABLE RENAME COLUMN (PostgreSQL 7.1.3)

2001-10-12 Thread Bruce Momjian
This appears to be fixed: test=> CREATE TABLE sheep (cow text); CREATE test=> CREATE INDEX goat ON sheep (cow); CREATE test=> ALTER TABLE sheep RENAME cow TO chicken; ALTER test=> \d sheep Table "sheep" Column | Typ

[BUGS] Possible bug in ALTER TABLE RENAME COLUMN (PostgreSQL 7.1.3)

2001-10-10 Thread Dave Page
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 h