From: Warren W. Gay VE3WWG <ve3wwg@cogeco.ca>
To: PostgreSQL mailing list <pgsql-interfaces@postgresql.org>
Subject: Re: determining if there's a transaction in progress
Date: Sat, 17 Aug 2002 00:46:13 -0400
Message-ID: <3D5DD515.4070302@cogeco.ca> (raw)
References: <Pine.BSF.4.20L2.0208160951340.48137-100000@mx1.gc.ny.otec.com>
<17444773280.20020816151103@carcass.dhs.org>
Steve Howe wrote:
>Hello Daniel,
>Friday, August 16, 2002, 10:54:26 AM, you wrote:
>DK> hi-
>DK> i'm using libpq. is there any way to determine if there is a transaction
>DK> is process thru libpq?
>
>There is not.
>
>
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.
Wish 2:
After performing an INSERT operation, with a column containing a serial
value,
it would be nice to obtain that serial value without having to resort to
a subsequent
SELECT on OID to get at it. INFORMIX (and ORACLE?) make this information
available to the embedded C/C++ clients. The same in libpq would be more
efficient.
Thanks, Warren.
--
Warren W. Gay VE3WWG
http://home.cogeco.ca/~ve3wwg
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ve3wwg@cogeco.ca
Subject: Re: determining if there's a transaction in progress
In-Reply-To: <3D5DD515.4070302@cogeco.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox