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
pgsql-general by date
|Next:||From: Tom Lane||Date: 2004-11-27 18:14:55|
|Subject: Re: how many JOINs ?|
|Previous:||From: Michael Fuhr||Date: 2004-11-27 17:50:47|
|Subject: Re: Can one alter the format of a numeric column?|