Skip site navigation (1) Skip section navigation (2)

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

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Question about object renaming in 9.0 (release note doc.)
Date: 2011-01-18 09:32:51
Message-ID: AANLkTinYB8faohF6igPiGwh9nyQEAsohZoL+ARwjZgLZ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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?

Responses

pgsql-novice by date

Next:From: JORGE MALDONADODate: 2011-01-18 17:21:12
Subject: Testing backup and restore
Previous:From: Plata Martínez, Álvaro (KNMI)Date: 2011-01-17 17:33:50
Subject: Postgis error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group