Re: How to implement a uniqueness constraint across multiple tables?

On Thu, Jul 31, 2014 at 3:52 PM, Kevin Grittner <kgrittn(at)ymail(dot)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.