PostgreSQL JDBC bug with XA recovery about pgjdbc

[ringerc]

On 07/18/2014 05:26 PM, Ravi Soni wrote:

Sorry, my fault. I've just copy-pasted SQL from previous topic. We have a
problem with multiple databases, it has nothing to do with users and
privileges.

What do we want, is
SELECT gid FROM pg_prepared_xacts where database = current_database()
in PGXAConnection.recover() function.

As I understand, you agree that it will fix the problem with multiple
databases. Could you please make a fix in official code shortly?

It'd also be a good idea to return only transactions for the current
user unless the current user is superuser.

Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

[rvsoni]

To return pending transaction, its need only database, as any valid user connected will be owner or super user, i dont see there are any case of using multiple user with same database. so this query will work nice to rollback transaction for owner or super user of postgres database.

[davecramer]

From what I can see this was resolved in PR #174