| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
| Cc: | "Dengler, Michael" <Michael_Dengler(at)tvworks(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Autocommit in libpq |
| Date: | 2007-03-13 15:29:00 |
| Message-ID: | 45F6C33C.2090307@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-13 15:29:09 | Re: Postgres batch write very slow - what to do |
| Previous Message | Heikki Linnakangas | 2007-03-13 15:15:28 | Re: Autocommit in libpq |