Moshe,
> How do I find out in Embedded SQL that a transaction has been aborted
> due to a deadlock?
I don't think anyone on the NOVICE list has much familiarity with Embedded
PGSQL. Try the HACKERS list instead.
FWIW, in 7.4 we will have SQLSTATE standards-compliant error codes which will
make analyzing such errors easier.
--
Josh Berkus
Aglio Database Solutions
San Francisco