On Thu, Aug 19, 2010 at 11:51 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> update session where id = X;
> update order where orderid = 5;
> update order where orderid = 5;
So i think this will already deadlock.
A has a exclusive-lock on session<X> and is waiting on order<5>. B has
an exclusive lock on order<5> and is waiting on a share-lock on
session<x>
> update order where orderid = 5;
> ... deadlock error.
>
Do you actually get a prompt here to type this command?
--
greg