Hi,
I’m trying to track down a deadlock happening in a live app. I’m wondering
about statements like this, which select more than one row to update:
update t set num = 1 where name = ‘foo’;
It appears to be causing a deadlock, but I can’t reproduce it on my test
database. Could two threads, each running this update, get in a deadlock? In
other words, are both of the following true:
1. The update locks each row in sequence, not all at once.
2. The order of the row locking could vary from one thread to the next.
thanks,
Rob
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
