From: Michael Fuhr <mike@fuhr.org>
To: osxdeveloper@mac.com
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Transactions and libpq
Date: Mon, 21 Aug 2006 17:28:14 -0600
Message-ID: <20060821232814.GA39874@winnie.fuhr.org> (raw)
In-Reply-To: <FF2C0679-5E61-4F33-B8E2-CD6770C9A31E@mac.com>
References: <FF2C0679-5E61-4F33-B8E2-CD6770C9A31E@mac.com>
On Tue, Aug 22, 2006 at 01:11:33AM +0200, osxdeveloper@mac.com wrote:
> I am writing an application using the libqpsql client lib.
Do you mean libpq? Are you coding in C?
> 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??
As the error says: a transaction had already been started when the
application tried to start another one. Can you post a simple but
complete program that demonstrates this behavior when you think it
shouldn't? You could also enable statement logging on the server
to see everything the application is executing.
> I searched Google and found some confusing things about serverside
> auto-commit - but this is removed at last in Postgres 8.0.
Server-side autocommit existed only in 7.3. What version of libpq
are you using, and what version of the server?
--
Michael Fuhr
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: mike@fuhr.org, osxdeveloper@mac.com
Subject: Re: Transactions and libpq
In-Reply-To: <20060821232814.GA39874@winnie.fuhr.org>
* 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