Re: Deadlock Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthias Schmitt <freak002(at)mmp(dot)lu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Deadlock Problem
Date: 2004-03-15 18:32:06
Message-ID: 24643.1079375526@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matthias Schmitt <freak002(at)mmp(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shilong Stanley Yao 2004-03-15 18:38:05 Character escape in "CREATE FUNCTION ..."
Previous Message Matthias Schmitt 2004-03-15 17:44:41 Deadlock Problem