Great, thanks for letting me know Bruce. Regards, Dave.
> -----Original Message----- > From: Bruce Momjian [mailto:[EMAIL PROTECTED]] > Sent: 12 October 2001 18:54 > To: Dave Page > Cc: '[EMAIL PROTECTED]' > Subject: Re: [BUGS] Possible bug in ALTER TABLE RENAME COLUMN > (PostgreSQL 7.1.3) > > > > 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 | Type | Modifiers > ---------+------+----------- > chicken | text | > Indexes: goat > > test=> \d goat > Index "goat" > Column | Type > ---------+------ > chicken | text > btree > > > -------------------------------------------------------------- > ------------- > > > 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 ([EMAIL PROTECTED]) > > http://pgadmin.postgresql.org/ > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > -- > Bruce Momjian | http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, > Pennsylvania 19026 > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
