Re: Unique Constraints using Non-Unique Indexes - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Unique Constraints using Non-Unique Indexes
Date
Msg-id 1206036116.4285.593.camel@ebony.site
Whole thread Raw
In response to Unique Constraints using Non-Unique Indexes  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Thu, 2008-03-20 at 17:38 +0000, Gregory Stark wrote:
> I don't immediately see any problems aside from reduced concurrency 

Agreed. The index would need to be nearly unique in most cases to make
it sensible. But that's a common situation in complex data models.

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com 
 PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk



pgsql-hackers by date:

Previous
From: Decibel!
Date:
Subject: Re: Lazy constraints / defaults
Next
From: Kurt Roeckx
Date:
Subject: gcc 4.3 breaks ContribCheck in 8.2 and older.