Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0E321476AE8; Fri, 16 Aug 2002 14:11:04 -0400 (EDT) Received: from sr1.terra.com.br (sr1.terra.com.br [200.176.3.16]) by postgresql.org (Postfix) with ESMTP id CCDF9476ABB; Fri, 16 Aug 2002 14:11:02 -0400 (EDT) Received: from penha.terra.com.br (penha.terra.com.br [200.176.3.43]) by sr1.terra.com.br (Postfix) with ESMTP id 465DE6FC31; Fri, 16 Aug 2002 15:11:02 -0300 (EST) Received: from 200.176.55.246 (cm-net-cwb-C8B037F6.brdterra.com.br [200.176.55.246]) (authenticated user howe) by penha.terra.com.br (Postfix) with ESMTP id E8FF4681D5; Fri, 16 Aug 2002 15:11:00 -0300 (EST) Date: Fri, 16 Aug 2002 15:11:03 -0300 From: Steve Howe X-Mailer: The Bat! (v1.61) Reply-To: Steve Howe Organization: ACME X-Priority: 3 (Normal) Message-ID: <17444773280.20020816151103@carcass.dhs.org> To: pgsql-interfaces-owner@postgresql.org, Daniel Kelley Cc: pgsql-interfaces@postgresql.org Subject: Re: determining if there's a transaction in progress In-Reply-To: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/54 X-Sequence-Number: 3016 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. DK> specifically, i'm looking for a function that would tell me whether or not DK> there are changes that should be committed to the db before program exit. If you want to ensure it, I suggest you to *always* start a transaction and then commit it at the end. ------------- Best regards, Steve Howe mailto:howe@carcass.dhs.org