Postgres Pro
Downloads
Home   >   mailing lists

Re: Deadlock with ShareLocks? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Deadlock with ShareLocks?
Date
Msg-id 6762.1134489145@sss.pgh.pa.us
Whole thread Raw
In response to Re: Deadlock with ShareLocks?  (Mario Weilguni <mweilguni@sime.com>)
Responses Re: Deadlock with ShareLocks?  (Mario Weilguni <mweilguni@sime.com>)
List pgsql-hackers
Tree view 
Mario Weilguni <mweilguni@sime.com> writes:
> Since the type field is PK, there cannot be 2 rows with type='list', I guess 
> the deadlock must have some different explanation.

Then the deadlock must involve rows in two different tables.  What else
are you doing in the same transaction(s) as updating last_modified?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regression test horology failure
Next
From: Mario Weilguni
Date:
Subject: Re: Deadlock with ShareLocks?