diff options
Diffstat (limited to 'doc/src/sgml/ref/alter_index.sgml')
| -rw-r--r-- | doc/src/sgml/ref/alter_index.sgml | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_index.sgml b/doc/src/sgml/ref/alter_index.sgml index c212fd09f93..b2df948d64c 100644 --- a/doc/src/sgml/ref/alter_index.sgml +++ b/doc/src/sgml/ref/alter_index.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/alter_index.sgml,v 1.6 2005/08/22 19:39:52 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/alter_index.sgml,v 1.7 2006/02/11 22:17:18 momjian Exp $ PostgreSQL documentation --> @@ -108,6 +108,15 @@ ALTER INDEX <replaceable class="PARAMETER">name</replaceable> SET TABLESPACE <re </para> <para> + Indexes are also used internally by constraints, namely by UNIQUE and + PRIMARY KEY constraints. If you rename an index that is used internally by + a constraint of that type, this constraint will implicitly be renamed as + well. On the other hand, if you rename such a constraint, it will + implicitly rename its corresponding index such that both objects always + have the same name. + </para> + + <para> There was formerly an <command>ALTER INDEX OWNER</> variant, but this is now ignored (with a warning). An index cannot have an owner different from its table's owner. Changing the table's owner |