Search Postgresql Archives

Re: Detecting uncommitted changes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In response to Thomas Kellerer <spam_eater@xxxxxxx>:

> 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 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".

-- 
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux