Skip site navigation (1) Skip section navigation (2)

Re: error message and documentation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivano Luberti <luberti(at)archicoop(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: error message and documentation
Date: 2009-09-30 16:24:10
Message-ID: 25982.1254327850@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Ivano Luberti <luberti(at)archicoop(dot)it> writes:
> My problem is I know what query has failed , but I don't know the other
> one that caused the deadlock condition.

Ah.  Is it practical for you to upgrade to PG 8.4?  IIRC the deadlock
reporting code got improved in 8.4 to log all the queries involved.

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Ivano LubertiDate: 2009-09-30 16:30:46
Subject: Re: error message and documentation
Previous:From: Ivano LubertiDate: 2009-09-30 16:07:35
Subject: Re: error message and documentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group