Postgres Pro
Downloads
Home   >   mailing lists

detecting deadlocks - Mailing list pgsql-general

From Jonathan Ellis
Subject detecting deadlocks
Date
Msg-id 009801c1a362$3a36b1b0$4a050a0a@jellispc
Whole thread Raw
Responses Re: detecting deadlocks
List pgsql-general
Tree view 
I get this logged

logger: ERROR:  Deadlock detected.
logger: ^ISee the lock(l) manual page for a possible cause.

but that's kind of useless to actually fix the problem.  Is there a way to
get it to log which two transactions are deadlocking?

I'm on 7.1.3...

-Jonathan

pgsql-general by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] PostgreSQL Licence: GNU/GPL
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] PostgreSQL Licence: GNU/GPL