PostrgreSQL does not support distributed transactions, so 2pc is impossible.
Check the mail list archives. Even on the JDBC list, there were some
exchanges of thoughts and opinions about XA and 2pc back a few months ago.
Peter
-----Original Message-----
From: David Hooker [mailto:dhooker@a4networks.com]
Sent: Sunday, March 24, 2002 8:33 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Two Phase commits
How does one perform a 2-phase commit against PostgreSQL? In reading the
JDBC driver code, the driver itself doesn't implement a 2pc protocol, so I'm
wondering if it's even possible to do. Any thoughts?