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

Re: Postgres XA support

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Michael Allman <msa(at)allman(dot)ms>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Postgres XA support
Date: 2005-08-16 00:12:31
Message-ID: 43012F6F.3020709@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Michael Allman wrote:

> Key to the protocol is the ability to start and end the association of
> transactions to threads of control.  In particular, what's bothering me
> is that there appears to be no way to end the transaction association of
> the current postgres connection, either permanently or for suspension.
> Please correct me if I'm wrong.
> 
> Thus work performed using the underlying physical connection of a
> PGXAResource unassociated with any transaction will still be performed
> on the connection's transaction.

You'll need another layer to support all of XA's behaviour -- this was
the discussion about mapping XA connections to physical connections that
happened on the list a while back, wasn't it?

It's probably unnecessary for the first cut, though. What exactly is the
behaviour that you can't support without that extra layer, and is it
needed for common use of XA? Seems to me that you could get away with
just disallowing work on a Connection that has an unprepared XA
transaction pending.

-O

In response to

Responses

pgsql-jdbc by date

Next:From: GabiosDate: 2005-08-16 02:21:39
Subject: unsubscribe
Previous:From: Michael AllmanDate: 2005-08-15 23:01:09
Subject: Re: Postgres XA support

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