Skip site navigation (1) Skip section navigation (2)

Re: Support for 2-Phase Commit protocol

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Alexander Staubo <alex(at)byzantine(dot)no>
Cc: Freddy Villalba Arias <fvillalba(at)madrid(dot)bilbomatica(dot)es>,PostgreSQL JDBC Mailing List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Support for 2-Phase Commit protocol
Date: 2004-03-29 16:35:59
Message-ID: 200403291635.i2TGZxR25130@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
Someone has a 2-phase commit patch and we are looking to get it into
7.5.


---------------------------------------------------------------------------

Alexander Staubo wrote:
> This is on the PostgreSQL todo list:
> 
>    http://developer.postgresql.org/todo.php
> 
> However, as far as I know it's not something people are working 
> actively on, or at least not to the extent that we will see a release 
> in the near term. I would like to be wrong, though.
> 
> Seeing as this is a server issue and not specifically a JDBC issue, 
> the pgsql-hackers list is probably the place to ask about the 
> development status of future features.
> 
> To my knowledge, Firebird (http://www.firebirdsql.org/) is the only 
> open-source database that supports two-phase commits; its JDBC driver 
> comes with JTA support. You may have better luck with that. Firebird 
> is itself a decent database, but is going to feel like a step back 
> into the '80s once you've gotten used to PostgreSQL's sleek, modern 
> facilities [*].
> 
> [*] Variable-length "text" data type that does not need a pre-declared 
> size, virtually unlimited row sizes, online alter/drop/rename for 
> tables/columns/etc., ability to index fields declared as >250 chars 
> long, SQL shell with proper readline support, intelligible error 
> messages, mature documentation, I could go on.
> 
> Alexander.
> 
> on 2004-03-29 17:19 Freddy Villalba Arias wrote:
> 
> > Hi everybody,
> > 
> >  
> > 
> > I forgot to include this other question (also urgent, sorry if I?m 
> > stressing you up): does anybody know what is PostgreSQL?s current status 
> > regarding ?Two Phase Commit Protocol Support??
> > 
> >  
> > 
> > Again, thanx.
> > 
> >  
> > 
> > Regards,
> > 
> > Freddy.
> > 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 

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

In response to

pgsql-jdbc by date

Next:From: Freddy Villalba AriasDate: 2004-03-29 17:43:16
Subject: Re: Support for 2-Phase Commit protocol
Previous:From: Alexander StauboDate: 2004-03-29 16:30:06
Subject: Re: OutOfMemory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group