On Thu, Aug 19, 2010 at 11:51 PM, Josh Berkus <j...@agliodbs.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers