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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
