Thread: PostgreSQL and XA Distributed Transaction Protocol

Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

Christian Ferrari wrote:
> I'm developing a new, free, XA compliant transaction manager.
> One of the first resource manager I would be glad to support 
> is PostgreSQL; after some googling I have found no 
> information related to PostgreSQL and XA protocol support.
> Can anyone give me more information related to this matter?

To the best of my knowledge, the only XA interface in PostgreSQL
is SQL.

A session participating in a distributed transaction would
issue "PREPARE TRANSACTION <name>", and the transaction manager
can "COMMIT PREPARED <name>" or "ROLLBACK PREPARED <name>".

The currently active prepared transactions cann be seen in
the pg_prepared_xacts system catalog.

That should be good enough to implement a transaction manager,
right?

Yours,
Laurenz Albe

Christian Ferrari wrote:
>>> Writing a specific stub to wrap-up PostgreSQL is not a too
>>> difficult task, but I would be sure I am not re-inventing the wheel.
>>> How can I am sure the standard XA interface is not availble?
>>> Do you know if there is any document about this matter?
>
>> I searched the archives and found some confirmation that there is no
such thing currently.
>> I also couldn't find anything on PgFoundry.
>> It might be a good idea to raise this on the pgsql-hackers list.
>> I think that might be something good to add to the core distribution.
>> At least it would be a good PgFoundry project!
>> Yours,
>> Laurenz Albe
>
> Dear all,
> now the LIXA project (http://sourceforge.net/projects/lixa/) is stable
enought to start the
> development of the XA interface for PostgreSQL and I'm going to
implement it for PostgreSQL 8.3
> Does anyone know if something has changed in the meantime? (Have
PostgreSQL yet implemented the
> standard native C XA library?).
>
> Any hints will be appreciated.

First, that question should be asked on the -hackers mailing list.
Don't start coding before your idea and design is approved there.
Furthermore, any new patch must be developed against HEAD and not an old
version of PostgreSQL.
Reading http://wiki.postgresql.org/wiki/Submitting_a_Patch is a good
starting point!

Yours,
Laurenz Albe