public inbox for [email protected]help / color / mirror / Atom feed
Add link to partial unique index from Constraints (5.3) 3+ messages / 3 participants [nested] [flat]
* Add link to partial unique index from Constraints (5.3) @ 2014-04-09 12:17 Tomáš Greif <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Tomáš Greif @ 2014-04-09 12:17 UTC (permalink / raw) To: pgsql-docs Hi, 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. Regards, Tomas ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Add link to partial unique index from Constraints (5.3) @ 2014-04-30 14:18 Robert Haas <[email protected]> parent: Tomáš Greif <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Robert Haas @ 2014-04-30 14:18 UTC (permalink / raw) To: Tomáš Greif <[email protected]>; +Cc: pgsql-docs 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. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Add link to partial unique index from Constraints (5.3) @ 2014-09-03 18:33 Bruce Momjian <[email protected]> parent: Robert Haas <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Bruce Momjian @ 2014-09-03 18:33 UTC (permalink / raw) To: Robert Haas <[email protected]>; +Cc: Tomáš Greif <[email protected]>; pgsql-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> ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2014-09-03 18:33 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-04-09 12:17 Add link to partial unique index from Constraints (5.3) Tomáš Greif <[email protected]> 2014-04-30 14:18 ` Robert Haas <[email protected]> 2014-09-03 18:33 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox