From: Joshua D. Drake <jd@commandprompt.com>
To: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: Dengler, Michael <Michael_Dengler@tvworks.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Autocommit in libpq
Date: Tue, 13 Mar 2007 08:29:00 -0700
Message-ID: <45F6C33C.2090307@commandprompt.com> (raw)
In-Reply-To: <45F6C010.3000207@enterprisedb.com>
References: <03C8E1672F290B44B20D46DB98ED36220588E19C@tvpmail.ad.liberate.com>
<45F6C010.3000207@enterprisedb.com>
Heikki Linnakangas wrote:
> Dengler, Michael wrote:
>> Please forgive me if I missed something (I have been searching for a
>> definitive answer for this for 2 days).
>>
>> Is there any way to disable autocommit in libpq? (PG 7.4.1)
>
> Just call BEGIN to start a transaction, and COMMIT to commit it. Other
> than that, no.
>
And very on topic, you need to upgrade ASAP to the latest 7.4.x.
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
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-performance@postgresql.org
Cc: jd@commandprompt.com, heikki@enterprisedb.com, Michael_Dengler@tvworks.com
Subject: Re: Autocommit in libpq
In-Reply-To: <45F6C33C.2090307@commandprompt.com>
* 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