X-Original-To: pgsql-interfaces-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D61BD9FB2B5 for ; Mon, 21 Aug 2006 18:11:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 75123-03 for ; Mon, 21 Aug 2006 18:11:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 249DB9FB2A9 for ; Mon, 21 Aug 2006 18:11:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.181]) by svr4.postgresql.org (Postfix) with ESMTP id 38BC25AF039 for ; Mon, 21 Aug 2006 21:11:24 +0000 (GMT) Received: from mac.com (smtpin07-en2 [10.13.10.152]) by smtpout.mac.com (Xserve/8.12.11/smtpout11/MantshX 4.0) with ESMTP id k7LLBKJr000603 for ; Mon, 21 Aug 2006 14:11:21 -0700 (PDT) Received: from [192.168.24.30] (pd954e9ed.dip0.t-ipconnect.de [217.84.233.237]) (authenticated bits=0) by mac.com (Xserve/smtpin07/MantshX 4.0) with ESMTP id k7LLBDKp005881 for ; Mon, 21 Aug 2006 14:11:17 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 7bit Message-Id: <7B099026-5BDE-4B53-BF81-8951A323A30C@mac.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: pgsql-interfaces@postgresql.org From: Ralf Hasemann Subject: libpgsql and transaction behaviour Date: Mon, 21 Aug 2006 23:11:11 +0200 X-Mailer: Apple Mail (2.752.2) X-Brightmail-Tracker: AAAAAQAAA+k= X-Language-Identified: TRUE X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/24 X-Sequence-Number: 6238 Hi! I am writing an application using the libqpsql client lib. What I like to do now, is to control transaction behavior from within my application. But the following happens: When I try to open a transaction libpg prints "WARNING: there is already a transaction in progress" to stdout. The question for me is - why?? I searched Google and found some confusing things about serverside auto-commit - but this is removed at last in Postgres 8.0. Can somebody lighten my about the reason for this problem? Thanks for any help! Regards, Ralf Hasemann