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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Wed, 30 Sep 2009 12:24:10 -0400
  • Message-id: <25982.1254327850@sss.pgh.pa.us> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group