pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAutocommit in libpq
5+ messages / 4 participants
[nested] [flat]
* Autocommit in libpq
@ 2007-03-13 14:55 Dengler, Michael <Michael_Dengler@tvworks.com>
0 siblings, 1 reply; 5+ messages in thread
From: Dengler, Michael @ 2007-03-13 14:55 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Autocommit in libpq
@ 2007-03-13 15:15 Heikki Linnakangas <heikki@enterprisedb.com>
parent: Dengler, Michael <Michael_Dengler@tvworks.com>
0 siblings, 1 reply; 5+ messages in thread
From: Heikki Linnakangas @ 2007-03-13 15:15 UTC (permalink / raw)
To: Dengler, Michael <Michael_Dengler@tvworks.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Autocommit in libpq
@ 2007-03-13 15:29 Joshua D. Drake <jd@commandprompt.com>
parent: Heikki Linnakangas <heikki@enterprisedb.com>
0 siblings, 1 reply; 5+ messages in thread
From: Joshua D. Drake @ 2007-03-13 15:29 UTC (permalink / raw)
To: Heikki Linnakangas <heikki@enterprisedb.com>; +Cc: Dengler, Michael <Michael_Dengler@tvworks.com>; 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/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Autocommit in libpq
@ 2007-03-13 16:03 Dengler, Michael <Michael_Dengler@tvworks.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 5+ messages in thread
From: Dengler, Michael @ 2007-03-13 16:03 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: 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@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/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Autocommit in libpq
@ 2007-03-13 16:13 Tom Lane <tgl@sss.pgh.pa.us>
parent: Dengler, Michael <Michael_Dengler@tvworks.com>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2007-03-13 16:13 UTC (permalink / raw)
To: Dengler, Michael <Michael_Dengler@tvworks.com>; +Cc: Joshua D. Drake <jd@commandprompt.com>; pgsql-performance
"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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-03-13 16:13 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-13 14:55 Autocommit in libpq Dengler, Michael <Michael_Dengler@tvworks.com>
2007-03-13 15:15 ` Heikki Linnakangas <heikki@enterprisedb.com>
2007-03-13 15:29 ` Joshua D. Drake <jd@commandprompt.com>
2007-03-13 16:03 ` Dengler, Michael <Michael_Dengler@tvworks.com>
2007-03-13 16:13 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox