Re: determining if there's a transaction in progress - Mailing list pgsql-interfaces

From Björn Lundin
Subject Re: determining if there's a transaction in progress
Date
Msg-id ajqbnu$25ma$1@news.hub.org
Whole thread Raw
In response to Re: determining if there's a transaction in progress  ("Warren W. Gay VE3WWG" <ve3wwg@cogeco.ca>)
List pgsql-interfaces
Warren W. Gay VE3WWG wrote:
<cut>

> I too could benefit from a libpq feature that indicates if a transaction
> is pending. This
> helps in determining in a destructor (or Ada finalization) whether the
> default action
> to rollback/commit is necessary (rather than depend upon the server
> default action).
> Assuming it is always necessary is clumsy, and imposes unnecessary
> overhead in
> situations where a transaction may not be in progress.
</cut>

In Ada, you could keep track of transaction state in a package.
Put 'start_trans', 'commit' and 'rollback' procedures that changes the 
transaction state accordingly. You'll then need a function 
'trans_in_progress' to check it

Example at http://home.swipnet.se/lundin/ada_95_tools.html

/Bj�rn


pgsql-interfaces by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: libpq++ and libpqxx moved to GBorg ...
Next
From: Frédéric Boucher
Date:
Subject: FreeBSD -pthread -lpq problem...