Re: Deadlock Problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Deadlock Problem
Date
Msg-id 24643.1079375526@sss.pgh.pa.us
Whole thread Raw
In response to Deadlock Problem  (Matthias Schmitt <freak002@mmp.lu>)
Responses Re: Deadlock Problem
List pgsql-general
Matthias Schmitt <freak002@mmp.lu> writes:
> I am in trouble with more and more deadlock problems. We are
> programming a web application with multiple users editing content at
> the same time. Multiple times a day PostgreSQL runs into a deadlock,
> which can only be resolved by killing some of the clients. Here is an
> example from the pg_locks table:

All of the rows you showed us have granted=t.  No blockage is evident,
let alone any deadlock.

            regards, tom lane

pgsql-general by date:

Previous
From: Matthias Schmitt
Date:
Subject: Deadlock Problem
Next
From: Shilong Stanley Yao
Date:
Subject: Character escape in "CREATE FUNCTION ..."