Trivial doc-patch for constraint description

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: pgsql-patches(at)postgresql(dot)org
Subject: Trivial doc-patch for constraint description
Date: 2005-12-05 12:27:46
Message-ID: 20051205122746.GA3242@mcknight.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hi,

there's a paragraph in the ALTER TABLE reference page that reads:

DROP CONSTRAINT

This form drops constraints on a table. Currently, constraints on tables
are not required to have unique names, so there may be more than one
constraint matching the specified name. All matching constraints will be
dropped.

To my knowledge, it is no longer possible to create constraints with the
same name for the same relation. When you create a constraint and specify
the same name explictly, an error is raised. Implicit constraint creation
won't choose an existing name either and up to now you could not rename a
constraint. Renaming works with the patch I sent in a few hours ago but this
patch as well won't allow constraints with identical names on the same
relation.

The attached patch thus removes the note in the docs.

Joachim

Attachment Content-Type Size
constraint_doc.diff text/plain 1019 bytes

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message John D. Burger 2005-12-05 13:24:16 Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Previous Message Volkan YAZICI 2005-12-05 11:09:35 mvcc.sgml make up