Tom Lane wrote on 28.12.2011 01:41:
Thomas Kellererspam_ea...@gmx.net writes:
Tom Lane wrote on 27.12.2011 20:22:
More specifically, look to see if the current transaction has assigned
itself a transaction ID. I think the easiest place to see this is in
pg_locks --- it will be holding
Hi,
is there a way I can detect if the current session has any uncommitted changes?
I'm not trying to find uncommitted changes from other sessions (connections)
only for the *current* one.
I thought there was a discussion on the mailing list that involved the txid_XXX
functions, but I
In response to Thomas Kellerer spam_ea...@gmx.net:
Hi,
is there a way I can detect if the current session has any uncommitted
changes?
I'm not trying to find uncommitted changes from other sessions (connections)
only for the *current* one.
I thought there was a discussion on the
Bill Moran wrote on 27.12.2011 19:37:
is there a way I can detect if the current session has any uncommitted changes?
I'm not trying to find uncommitted changes from other sessions (connections)
only for the *current* one.
I thought there was a discussion on the mailing list that involved the
Thomas Kellerer spam_ea...@gmx.net writes:
Bill Moran wrote on 27.12.2011 19:37:
is there a way I can detect if the current session has any uncommitted
changes?
If I'm understanding you correctly, you could just make it check the
transaction status. If there's an active transaction, then
Tom Lane wrote on 27.12.2011 20:22:
If I'm understanding you correctly, you could just make it check the
transaction status. If there's an active transaction, then there are
uncommitted changes.
Sounds like what I want, but how do I check the transaction status (I'm using
JDBC)
More
Thomas Kellerer spam_ea...@gmx.net writes:
Tom Lane wrote on 27.12.2011 20:22:
More specifically, look to see if the current transaction has assigned
itself a transaction ID. I think the easiest place to see this is in
pg_locks --- it will be holding exclusive lock on a TransactionId object