Postgres Pro
Downloads
Home   >   mailing lists

Thread: Add link to partial unique index from Constraints (5.3)

Add link to partial unique index from Constraints (5.3)

From
Tomáš Greif
Date:
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

Re: Add link to partial unique index from Constraints (5.3)

From
Robert Haas
Date:
On Wed, Apr 9, 2014 at 8:17 AM, Tomáš Greif
<tomas.greif@collectionspro.eu> 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

Re: Add link to partial unique index from Constraints (5.3)

From
Bruce Momjian
Date:
On Wed, Apr 30, 2014 at 10:18:22AM -0400, Robert Haas wrote:
> On Wed, Apr 9, 2014 at 8:17 AM, Tomáš Greif
> <tomas.greif@collectionspro.eu> 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  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +
Attachment