2-phase commit - Mailing list pgsql-general

From richard excite
Subject 2-phase commit
Date
Msg-id 33176431.967083048321.JavaMail.imail@dotty.excite.com
Whole thread Raw
List pgsql-general
Hello,

Is there any open source implementation of 2-phase commit out there using
Postgres ?
The basic logic says :

MASTER                               SLAVE
------                               ------
begin atomic action
send request 1-n
send "prepare to commit message"
                                     if action_can_be_performed
                                        lock data
                                        store initial state on disk
                                        store request on disk
                                        send "ok" message
                                     else
                                        send "failure" message
if all slaves said "ok"
     send "commit" message
else
     send "rollback" message
Wait for acknowledgements
                                     if master said commit
                                       do work
                                       unlock data

                                     Send "acknowledgement" message


How can I check "action_can_be_performed" (i.e. what conditions satisfy an
"ok" vote ?)
thanks for your time.
-richard





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html


pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Count & Distinct
Next
From: Mario Weilguni
Date:
Subject: Problem with rules & ODBC