Обсуждение: Add link to partial unique index from Constraints (5.3)

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

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. +