| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Detecting uncommitted changes |
| Date: | 2011-12-27 18:49:27 |
| Message-ID: | jdd3u9$drp$1@dough.gmane.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 txid_XXX functions, but I couldn't find that anymore.
>>
>> Background:
>> I'm trying to implement a "Do you want to commit your changes?" question in a SQL tool, when the user closes the application.
>
> 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)
Regards
Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jacques Lamothe | 2011-12-27 19:07:35 | UNABLE TO CONNECT REMOTELY TO port 5436 - CRITICAL |
| Previous Message | Bill Moran | 2011-12-27 18:37:54 | Re: Detecting uncommitted changes |