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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

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/


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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/


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

"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/pgdo...s/release.html

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org