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                        |
  [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]

Reply via email to