Re: row-level deadlock problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Kamil Kaczkowski <kamil(at)kamil(dot)eisp(dot)pl>, pgsql-general(at)postgresql(dot)org
Subject: Re: row-level deadlock problem
Date: 2004-11-27 17:58:36
Message-ID: 26785.1101578316@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> Well, there has to be something, since an UPDATE in Read Committed mode
> simply doesn't have any locks that can deadlock.

You're mistaken; it takes a row lock on each row it updates. I'm not
sure why the two UPDATEs are visiting the same rows in different orders,
but if they do the failure is certainly possible.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-27 18:14:55 Re: how many JOINs ?
Previous Message Michael Fuhr 2004-11-27 17:50:47 Re: Can one alter the format of a numeric column?