On 20 August 2010 09:39, Josh Berkus <j...@agliodbs.com> wrote: > On 8/19/10 3:51 PM, Josh Berkus wrote: >> Kevin, >> >> This one is for you: >> >> Two sessions, in transaction: >> >> Process A Process B >> >> update session where id = X; >> update order where orderid = 5; >> update order where orderid = 5; >> update order where orderid = 5; >> ... deadlock error. > > Johto on IRC pointed out I left something out of the above: "session" is > referenced in an FK by "orders", and session = X is related to orderid = 5. >
I was wondering what that had to do with anything. -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers