Re: Autocommit in libpq

From: "Dengler, Michael" <Michael_Dengler(at)tvworks(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Autocommit in libpq
Date: 2007-03-13 16:03:47
Message-ID: 03C8E1672F290B44B20D46DB98ED36220588E2CE@tvpmail.ad.liberate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thanks for the reply. Your advice to upgrade sounds urgent. Are there critical reasons I need to go to 7.4.16?

Thanks

Mike

-----Original Message-----
From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
Sent: March 13, 2007 11:29 AM
To: Heikki Linnakangas
Cc: Dengler, Michael; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Autocommit in libpq

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/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-03-13 16:13:55 Re: Autocommit in libpq
Previous Message Tom Lane 2007-03-13 16:02:26 Re: Postgres batch write very slow - what to do