Horton
Menu

Re: Deadlock bug

Simon Riggs <simon@2ndquadrant.com>

View thread
From: Simon Riggs <simon@2ndQuadrant.com>
To: Markus Wanner <markus@bluegap.ch>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Josh Berkus <josh@agliodbs.com>, Joel Jacobson <joel@gluefinance.com>, Kevin Grittner <Kevin.Grittner@wicourts.gov>, Magnus Hagander <magnus@hagander.net>, pgsql-hackers@postgresql.org
Date: 2010-08-25T14:02:48Z
Lists: pgsql-hackers 
On Wed, 2010-08-25 at 15:51 +0200, Markus Wanner wrote:
> Simon,
> 
> On 08/25/2010 11:53 AM, Simon Riggs wrote:
> > ..we want to ensure that the PK value..
> 
> ..or any other possibly referenced attributes?

Don't think that's relevant.

"referenced" meaning "by an RI constraint", which only ever refers to
PKs in other tables.

As a result the proposal is safe and useful for 99% of cases.

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