Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER RENAME and indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER RENAME and indexes
Date
Msg-id 6961.1002289608@sss.pgh.pa.us
Whole thread Raw
In response to typo in src/interfaces/ecpg/preproc/preproc.y  (Brent Verner <brent@rcfile.org>)
Responses Re: ALTER RENAME and indexes
List pgsql-hackers
Tree view 
Brent Verner <brent@rcfile.org> writes:
> 'ALTER TABLE tbl RENAME col1 TO col2' does not update any indices that
> reference the old column name.

It doesn't need to; the indexes link to column numbers, not column
names.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Alex Avriette
Date:
Subject: Darwin 1.4 (OS X 10.1) Broken Compile, Snapshot and 7.1.3
Next
From: Tom Lane
Date:
Subject: Re: Darwin 1.4 (OS X 10.1) Broken Compile, Snapshot and 7.1.3