Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I sure want two-phase commit. I don't remember it as being rejected, > > and we certainly need it, independent of replication. > > Is 2PC a real-world solution to any real-world problem? I have never > seen a satisfactory explanation of what you do when you've reported that > you're ready to commit and no confirmation ever comes back. Sooner or > later you must violate the protocol in one direction or the other (ie, > commit without confirmation or roll back in violation of your promise > of being able to commit). > > I think it's a cool-sounding phrase that does not actually work in > practice.
I think 2PC can be used to build more complex features, like using dblink for cross-db modification queries. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]