Detecting uncommitted changes

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Detecting uncommitted changes
Date: 2011-12-27 18:30:10
Message-ID: jdd2q7$79p$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Regards
Thomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2011-12-27 18:37:54 Re: Detecting uncommitted changes
Previous Message Ben Chobot 2011-12-27 17:34:34 Re: invalid memory alloc request size