Re: "deadlock detected" documentation

Matt Mello <alien@spaceship.com> writes:
> I see.  One item I forgot to mention ...  Both update statements have a 
> where clause containing txn.terminalid=38.  Txn.terminalid is a foreign 
> key column in that table (txn.terminalid->terminal.terminalid).  Could 
> this be the source of the trouble?

Not per se.  The problem depends on which rows get updated and in what
sequence --- the contents of the WHERE clause aren't the issue, except
insofar as they determine the set of rows to be updated.
        regards, tom lane