Re: two phase commit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben <bench(at)silentmedia(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: two phase commit
Date: 2007-07-19 23:13:34
Message-ID: 12680.1184886814@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ben <bench(at)silentmedia(dot)com> writes:
> Er, right.... I guess I should have asked if it's more likely to commit a
> running transaction than a prepared one.... and it sounds like the answer
> is "no". :)

Less likely, because PREPARE TRANSACTION executes all the COMMIT-time
actions that can cause "expected" failures --- checking deferred
constraints for example. If you get past that, it's not supposed to fail.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zlatko Matić 2007-07-20 06:21:28 several postgres installations on the same machine?
Previous Message Ben 2007-07-19 22:49:02 Re: two phase commit