Of course I have no time to work on it : (, but in my opinion XA interface and support for the JDBC driver is absolutely necessary. I think that 2pc will generally be used more for supporting 2pc transactions between the DB and JMS than it would be for 2pc across 2 db's.
Glad to see some progress on 2PC with Postgres though. Later Rob > > The next step is going to be writing 2PC support to the JDBC driver using > the new backend commands. XA interface would be very nice too, but I'm > personally not that interested in that. Any volunteers? > > Please comment! I'd like to know what you guys think about this. Am I > heading into the right direction? > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match