Skip site navigation (1) Skip section navigation (2)

Re: Autocommit

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Hasnul Fadhly bin Hasan <hasnulfadhly(dot)h(at)mimos(dot)my>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autocommit
Date: 2005-02-14 09:34:03
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
On Mon, Feb 14, 2005 at 04:58:31PM +0800, Hasnul Fadhly bin Hasan wrote:

> Thanks for the reply.  I am using postgres 7.4.5 client.  There's one 
> that is using 7.4.1 client.  I'm not sure if there would be any difference.
> When i use psql and check the status of autocommit, it is set to 
> enable.  I'm not sure if libpq and psql uses the same defaults.

As far as I can tell, libpq doesn't have an autocommit setting --
it just sends statements on behalf of the application.  Clients
that allow the user to disable autocommit presumably do so by
implicitly sending BEGIN statements to start new transactions.

Michael Fuhr

In response to

pgsql-performance by date

Next:From: Harald FuchsDate: 2005-02-14 10:46:18
Subject: Re: Benchmark
Previous:From: Hasnul Fadhly bin HasanDate: 2005-02-14 08:58:31
Subject: Re: Autocommit

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group