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

Поиск
Список
Период
Сортировка
От Kynn Jones
Тема Re: How to implement a uniqueness constraint across multiple tables?
Дата
Msg-id CAFvQaj66Wq5y+bHM4-x9TkMZfWVeptsLtjp3SZiwekCrvrDdvQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to implement a uniqueness constraint across multiple tables?  (Kevin Grittner <kgrittn@ymail.com>)
Список 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 по дате отправления:

Предыдущее
От: Kynn Jones
Дата:
Сообщение: Re: How to implement a uniqueness constraint across multiple tables?
Следующее
От: Larry White
Дата:
Сообщение: Re: Very Limited Toast Compression on JSONB (9.4 beta 2)