Horton
Menu

Re: Deadlock bug

Nicolas Barbier <nicolas.barbier@gmail.com>

View thread
From: Nicolas Barbier <nicolas.barbier@gmail.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Markus Wanner <markus@bluegap.ch>, pgsql-hackers@postgresql.org
Date: 2010-08-25T14:23:41Z
Lists: 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