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
