Deadlock Detection - Mailing list pgsql-hackers

From Moshe Vardi
Subject Deadlock Detection
Date
Msg-id 200310271717.h9RHHbQj016685@verif.cs.rice.edu
Whole thread Raw
List pgsql-hackers
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
rollbackthe  transaction. 
 

but it does not seem to be informative enough.

Similarly, how do I find if a transaction has been aborted due to
nonserializability?

Thanks,
Moshe



pgsql-hackers by date:

Previous
From: "Thiago Fernandes Moesch"
Date:
Subject: When the last vacuum occured? It's necessary to run it now?
Next
From: strk
Date:
Subject: Re: DETOASTing in custom memory context