Re: Unique Constraints using Non-Unique Indexes

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Unique Constraints using Non-Unique Indexes
Date: 2008-03-20 18:01:56
Message-ID: 1206036116.4285.593.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-03-20 18:03:11 Re: [PATCHES] [GENERAL] Empty arrays with ARRAY[]
Previous Message Simon Riggs 2008-03-20 18:00:01 Re: Unique Constraints using Non-Unique Indexes