Bruce Momjian <pgman@candle.pha.pa.us> 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.
regards, tom lane