pgsql: Fix ALTER INDEX RENAME so that if the index belongs to a unique

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix ALTER INDEX RENAME so that if the index belongs to a unique
Date: 2008-01-17 18:56:54
Message-ID: 20080117185654.9AC6E754108@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Fix ALTER INDEX RENAME so that if the index belongs to a unique or primary key
constraint, the constraint is renamed as well. This avoids inconsistent
situations that could confuse pg_dump (not to mention humans). We might at
some point provide ALTER TABLE RENAME CONSTRAINT as a more general solution,
but there seems no reason not to allow doing it this way too. Per bug #3854
and related discussions.

Modified Files:
--------------
pgsql/src/backend/catalog:
pg_constraint.c (r1.37 -> r1.38)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_constraint.c?r1=1.37&r2=1.38)
pgsql/src/backend/commands:
tablecmds.c (r1.239 -> r1.240)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.239&r2=1.240)
pgsql/src/include/catalog:
pg_constraint.h (r1.26 -> r1.27)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_constraint.h?r1=1.26&r2=1.27)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2008-01-17 20:35:28 pgsql: Fix subselect.c to avoid assuming that a SubLink's testexpr
Previous Message Bruce Momjian 2008-01-17 18:53:20 pgsql: Update Japanese FAQ.