Add link to partial unique index from Constraints (5.3)
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
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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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
<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. +