Re: Deadlock bug

Поиск
Список
Период
Сортировка
От Nicolas Barbier
Тема Re: Deadlock bug
Дата
Msg-id AANLkTim3TF1b7n+KZ_rTAi7ujGHzsiM9zRwaDEY2UDh=@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Deadlock bug  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Deadlock bug  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
2010/8/25 Simon Riggs <simon@2ndquadrant.com>:

> On Wed, 2010-08-25 at 16:14 +0200, Nicolas Barbier wrote:
>> 2010/8/25 Simon Riggs <simon@2ndquadrant.com>:
>>
>> > "referenced" meaning "by an RI constraint", which only ever refers to
>> > PKs in other tables.
>>
>> FK constraints can also point to non-PK UNIQUE columns.
>
> You're exactly correct and I now understand Markus' comment. Do you
> think that exact meaning prevents my proposal from being useful?

Not at all, because I guess that updates to non-UNIQUE columns are way
more common that updates to UNIQUE columns.

Nicolas


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Deadlock bug
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Deadlock bug