Postgresql XA prepare() method behaviour

From: Francesco Degrassi <francesco(dot)degrassi(at)emaze(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Postgresql XA prepare() method behaviour
Date: 2010-11-30 18:42:51
Message-ID: 4CF545AB.4090207@emaze.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello all.
A couple of weeks ago I stumbled upon a strange behaviour of postgresql
jdbc driver that I think was initially identified almost 5 years ago.
The problem i'm referring to is this:

http://archives.postgresql.org/message-id/Pine.OSF.4.61.0602121957130.244416@kosh.hut.fi

It seems to me that the patch never made it into trunk;
the current source from CVS still returns XA_OK from prepare() when the
"PREPARE TRANSACTION" command returns "ROLLBACK" (as is the case when a
statement like "SELECT * FROM table_that_does_not_exists" was executed
in transaction).

I contacted the original author, Heikki Linnakangas, and he told me that
the patch was a little bit messy and that it probably simply got
forgotten, and urged me to raise the question here again, since one way
or another it should be fixed.

Regards

--
Francesco Degrassi

Emaze Networks S.p.A
www.emaze.net

Browse pgsql-jdbc by date

  From Date Subject
Next Message Radosław Smogura 2010-11-30 18:49:03 Improved JDBC driver part 2
Previous Message Radosław Smogura 2010-11-26 18:28:52 Storing timestamps in text format