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