Re: Question about object renaming in 9.0 (release note doc.)

On Tue, Jan 18, 2011 at 4:32 AM, A B <gentosaker(at)gmail(dot)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