Thread: Autocommit in libpq
Hi,
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)
Thanks
Mike
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. -- Heikki Linnakangas EnterpriseDB http://www.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/
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@commandprompt.com] Sent: March 13, 2007 11:29 AM To: Heikki Linnakangas Cc: Dengler, Michael; pgsql-performance@postgresql.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/
"Dengler, Michael" <Michael_Dengler@tvworks.com> writes: > Thanks for the reply. Your advice to upgrade sounds urgent. Are there critical reasons I need to go to 7.4.16? Read the release notes between 7.4.1 and 7.4.16 and judge for yourself: http://developer.postgresql.org/pgdocs/postgres/release.html regards, tom lane