Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks - Mailing list pgsql-general

From Ben Chobot
Subject Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks
Date
Msg-id 34867911-3DC4-48F9-BD73-975AE9748CCD@silentmedia.com
Whole thread Raw
In response to Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

On Apr 25, 2012, at 1:31 PM, Tom Lane wrote:

I don't have all the details in my head, but if you deliberately provoke
a deadlock by making two transactions update the same two rows in
opposite orders, you'll soon find out what it looks like in the log.

Heh, duh. Looks like your first guess was correct, as usual. Conflicting updates in two transactions show up in the logs as a ShareLock deadlock.

Thanks!

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks
Next
From: Tom Lane
Date:
Subject: Re: Updates, ShareLocks, RowExclusiveLocks, and deadlocks