Re: Deadlock with ShareLocks?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mario Weilguni <mweilguni(at)sime(dot)com>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Deadlock with ShareLocks?
Date: 2005-12-13 15:52:25
Message-ID: 6762.1134489145@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Mario Weilguni <mweilguni(at)sime(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mario Weilguni 2005-12-13 15:57:54 Re: Deadlock with ShareLocks?
Previous Message Tom Lane 2005-12-13 15:46:52 Re: Regression test horology failure