Re: Avoiding deadlocks ...

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