Re: Avoiding deadlocks ...

From: Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Avoiding deadlocks ...
Date: 2010-08-20 15:23:07
Message-ID: 4C6E9DDB.9010009@cs.helsinki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2010-08-20 6:19 PM, Kevin Grittner wrote:
> Marko Tiikkaja<marko(dot)tiikkaja(at)cs(dot)helsinki(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joel Jacobson 2010-08-20 16:16:27 Re: Deadlock bug
Previous Message Tom Lane 2010-08-20 15:19:51 Re: Deadlock bug