Re: Support for distributed transactions in 8.2.5

Brian Oki (boki) wrote:
> My question is this: How does PostgreSQL 8.2.5 execute DML statements
> (insert, update, delete, select) on remote nodes as part of the same
> transaction? Where is the syntax specified? Or, is there a different
> model supported? It's sort of like the synchronous multi-master
> replication mentioned in Chapter 24. I'm looking for an integrated
> solution.

It doesn't, there isn't, and no.

I'm afraid the 2-phase commit in 8.2 is there as a building-block for
this sort of thing, rather than a complete solution in itself.

I believe there are some Java tools that might help you here.

--
   Richard Huxton
   Archonet Ltd