Horton
Menu

Re: Deadlock bug

Simon Riggs <simon@2ndquadrant.com>

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

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Development, 24x7 Support, Training and Services