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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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