Re: Support for 2-Phase Commit protocol

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.
>