public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Robert Haas <[email protected]>
Cc: Tomáš Greif <[email protected]>
Cc: pgsql-docs <[email protected]>
Subject: Re: Add link to partial unique index from Constraints (5.3)
Date: Wed, 3 Sep 2014 14:33:41 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+TgmoaTtJk6ZR-RmxQ6enUfX3XkuvzyGNLutpZkwT5NWesT1w@mail.gmail.com>
References: <CAGKU+8Ds=3Co=mcf1VN+3kGszDaoBj7Q17c6bpM43Z+iYaHL2w@mail.gmail.com>
<CA+TgmoaTtJk6ZR-RmxQ6enUfX3XkuvzyGNLutpZkwT5NWesT1w@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>
On Wed, Apr 30, 2014 at 10:18:22AM -0400, Robert Haas wrote:
> On Wed, Apr 9, 2014 at 8:17 AM, Tomáš Greif
> <[email protected]> wrote:
> > would it be good idea to add new paragraph 5.3.7 to chapter 5.3
> > (Constraints) with at least information that there is something like partial
> > unique index and link to chapter 11.8 (Partial Indexes)?
> >
> > Partial index can be used to enforce uniqueness in a way other constraints
> > cannot provide. Currently, it not easy to find this type of constraint as
> > not a lot of people would read through documentation on indexes when looking
> > for constraints.
>
> I think adding something to that chapter would be good.
Attached patch applied, and backpatched to 9.4.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments:
[text/x-diff] partial.diff (756B, 2-partial.diff)
download | inline diff:
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
new file mode 100644
index 0fcd9f8..c07f5a2
*** a/doc/src/sgml/ddl.sgml
--- b/doc/src/sgml/ddl.sgml
*************** CREATE TABLE products (
*** 546,552 ****
<para>
Adding a unique constraint will automatically create a unique btree
! index on the column or group of columns used in the constraint.
</para>
<indexterm>
--- 546,554 ----
<para>
Adding a unique constraint will automatically create a unique btree
! index on the column or group of columns used in the constraint.
! A uniqueness constraint on only some rows can be enforced by creating
! a <link linkend="indexes-partial">partial index</link>.
</para>
<indexterm>
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Add link to partial unique index from Constraints (5.3)
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox