Обсуждение: Question about object renaming in 9.0 (release note doc.)

Hello.

I read in the release notes for 9.0

"No longer automatically rename indexes and index columns when the
underlying table columns are renamed (Tom Lane) "

What does this mean?

If I have a table with a column "x" with an index on the column, and
change it to y, the name of the index will not change. That's fine,
but the  part  "index columns", will the index definition refer to a
column (x) that no longer exists? I might have gotten this completly
wrong, so please could some one clarify?

On Tue, Jan 18, 2011 at 4:32 AM, A B <gentosaker@gmail.com> wrote:
> Hello.
>
> I read in the release notes for 9.0
>
> "No longer automatically rename indexes and index columns when the
> underlying table columns are renamed (Tom Lane) "
>
> What does this mean?

I think that's referring to this commit:
http://archives.postgresql.org/pgsql-committers/2009-12/msg00209.php

> If I have a table with a column "x" with an index on the column, and
> change it to y, the name of the index will not change. That's fine,
> but the  part  "index columns", will the index definition refer to a
> column (x) that no longer exists? I might have gotten this completly
> wrong, so please could some one clarify?

If you rename an indexed column, the index should figure out what happened.

Josh