Re: Deadlock bug - Mailing list pgsql-hackers

From Nicolas Barbier
Subject Re: Deadlock bug
Date
Msg-id AANLkTim3TF1b7n+KZ_rTAi7ujGHzsiM9zRwaDEY2UDh=@mail.gmail.com
Whole thread Raw
In response to Re: Deadlock bug  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Deadlock bug
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Deadlock bug
Next
From: Greg Stark
Date:
Subject: Re: Deadlock bug