2-phase commit

From: richard excite <richard_excite(at)excite(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: 2-phase commit
Date: 2000-08-23 07:08:00
Message-ID: 14794238.967014480724.JavaMail.imail@dotty.excite.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Gilles DAROLD 2000-08-23 08:01:50 Re: Fw: Problem starting PostgreSQL
Previous Message richard excite 2000-08-23 07:02:55 VARCHAR with null