Re: Two-phase commit issues

Tom Lane wrote:
> I've started to look seriously at Heikki's patch for two-phase commit.
> There are a few issues that probably deserve discussion:
> 
> * The major missing issue that I've come across so far is that
> subtransaction and multixact state isn't preserved across a crash.

I am a little confused by this.  How does two-phase commit add extra
requirements on crash recovery?  I understand a crashed server might be
involved in a two-phase commit, but doesn't the transaction just roll
back?

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