Re: Two-phase commit issues

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Tom Lane wrote:
> >> Uh, that's more or less the entire *POINT*.  Once an open transaction is
> >> prepared, it's supposed to survive a server crash.
> 
> > Wow.  This is much more than I thought we were going to do.
> 
> If we tried to claim that anything less was two-phase commit, we'd be
> laughed off the face of the planet ...

Well, based on past discussions, our TODO has:
* Add two-phase commit  This will involve adding a way to respond to commit failure by either  taking the server into
offline/readonlymode or notifying the  administrator
 

As I remember, you said two-phase wasn't 100% reliable and we just
needed a way to report failures.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073