Re: Autocommit in libpq - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: Autocommit in libpq
Date
Msg-id 45F6C33C.2090307@commandprompt.com
Whole thread Raw
In response to Re: Autocommit in libpq  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: Autocommit in libpq
List pgsql-performance
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/


pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Autocommit in libpq
Next
From: Tom Lane
Date:
Subject: Re: Postgres batch write very slow - what to do