Quick Links

Re: ALTER RENAME and indexes

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Brent Verner <brent(at)rcfile(dot)org>
Cc:	pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: ALTER RENAME and indexes
Date:	2001-10-05 13:46:48
Message-ID:	6961.1002289608@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

Brent Verner <brent(at)rcfile(dot)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

In response to

typo in src/interfaces/ecpg/preproc/preproc.y at 2001-10-05 03:38:24 from Brent Verner

Responses

Re: ALTER RENAME and indexes at 2001-10-05 14:18:17 from Brent Verner

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Neil Tiffin	2001-10-05 14:06:53	Re: Darwin 1.4 (OS X 10.1) Broken Compile, Snapshot and
Previous Message	Alex Avriette	2001-10-05 13:41:29	Darwin 1.4 (OS X 10.1) Broken Compile, Snapshot and 7.1.3