Re: Avoiding deadlocks ... - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: Avoiding deadlocks ...
Date
Msg-id 4C6E9DDB.9010009@cs.helsinki.fi
Whole thread Raw
In response to Re: Avoiding deadlocks ...  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Avoiding deadlocks ...  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On 2010-08-20 6:19 PM, Kevin Grittner wrote:
> Marko Tiikkaja<marko.tiikkaja@cs.helsinki.fi>  wrote:
>
>> I think truly serializable transactions still need to SELECT FOR
>> SHARE here for foreign keys to work, no?
>
> That depends on how you look at it.  The SSI patch that Dan and I
> have been working on doesn't attempt to change the implementation
> techniques for foreign keys, because SSI only enforces integrity
> among serializable transactions -- and we want foreign keys to be
> enforced regardless of the transaction isolation levels used.

Exactly.


Regards,
Marko Tiikkaja


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Deadlock bug
Next
From: Joel Jacobson
Date:
Subject: Re: Deadlock bug