Re: How to implement a uniqueness constraint across multiple tables? - Mailing list pgsql-general

From Kynn Jones
Subject Re: How to implement a uniqueness constraint across multiple tables?
Date
Msg-id CAFvQaj66Wq5y+bHM4-x9TkMZfWVeptsLtjp3SZiwekCrvrDdvQ@mail.gmail.com
Whole thread Raw
In response to Re: How to implement a uniqueness constraint across multiple tables?  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-general
On Thu, Jul 31, 2014 at 3:52 PM, Kevin Grittner <kgrittn@ymail.com> wrote:

This goes beyond the capabilities of declarative constraints to
enforce.  You can enforce it using triggers, but you need to handle
race conditions, which is not easy with MVCC behavior (where reads
don't block anything and writes don't block reads).  There are
basically two ways to cover that:
<snip>

Thanks for the detailed response.  It gives me much to work with/follow-up on.


pgsql-general by date:

Previous
From: Kynn Jones
Date:
Subject: Re: How to implement a uniqueness constraint across multiple tables?
Next
From: Larry White
Date:
Subject: Re: Very Limited Toast Compression on JSONB (9.4 beta 2)