The Hermit Hacker <[EMAIL PROTECTED]> writes: > Hrmmm, I see Tom's point (I think!) ... but what if, for instance, the > co-ordinator crashes?
Or you just lose the network connection for awhile. The worst case scenario I think is where the co-ordinator got everyone's promise to commit, and told some of the subordinates to commit, but your own response gets lost due to network failure. Now what? If you time out and decide to abort, you're inconsistent with the other subordinates. On the other hand, you can't commit after a timeout either, because that loses in the other scenario (where the coordinator didn't decide to commit). Basically, the subordinate must be willing to hold its breath *forever*. I don't see how this can work. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]