Postgres Pro
Downloads
Home   >   mailing lists

Deadlock Detection - Mailing list pgsql-novice

From vardi@cs.rice.edu (Moshe Vardi)
Subject Deadlock Detection
Date
Msg-id 20031026213247.EDBFF4AA53@cs.rice.edu
Whole thread Raw
Responses Re: Deadlock Detection  (Josh Berkus <josh@agliodbs.com>)
List pgsql-novice
Tree view 
How do I find out in Embedded SQL that a transaction has been aborted
due to a deadlock?

The closes error message in sqlca seems to be:

  -401 (ECPG_TRANS): Error in transaction processing line %d.
   PostgreSQL signaled that we cannot start, commit, or rollback the
   transaction.

but it does not seem to be informative enough.


Thanks,

Moshe Vardi
Rice University

pgsql-novice by date:

Previous
From: Peter Childs
Date:
Subject: Re: Using older machines with PostgreSQL?
Next
From: Josh Berkus
Date:
Subject: Re: Deadlock Detection