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@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
