Detecting uncommitted changes - Mailing list pgsql-general

From Thomas Kellerer
Subject Detecting uncommitted changes
Date
Msg-id jdd2q7$79p$1@dough.gmane.org
Whole thread Raw
Responses Re: Detecting uncommitted changes  (Bill Moran <wmoran@potentialtech.com>)
List 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

pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: Re: invalid memory alloc request size
Next
From: Bill Moran
Date:
Subject: Re: Detecting uncommitted changes