Skip site navigation (1) Skip section navigation (2)

Re: determining if there's a transaction in progress

From: "Warren W(dot) Gay VE3WWG" <ve3wwg(at)cogeco(dot)ca>
To: PostgreSQL mailing list <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: determining if there's a transaction in progress
Date: 2002-08-17 04:46:13
Message-ID: 3D5DD515.4070302@cogeco.ca (view raw or flat)
Thread:
Lists: pgsql-interfaces
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




In response to

Responses

pgsql-interfaces by date

Next:From: Warren W. Gay VE3WWGDate: 2002-08-17 04:56:31
Subject: Transaction Abort State?
Previous:From: Warren W. Gay VE3WWGDate: 2002-08-17 04:39:53
Subject: libpq bug handling signals

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group