Re: A bad behavior under autocommit off mode - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: A bad behavior under autocommit off mode
Date
Msg-id 200303200456.h2K4uRP22779@candle.pha.pa.us
Whole thread Raw
In response to Re: A bad behavior under autocommit off mode  (Neil Conway <neilc@samurai.com>)
Responses Re: A bad behavior under autocommit off mode
List pgsql-hackers
Neil Conway wrote:
> On Wed, 2003-03-19 at 23:36, Bruce Momjian wrote:
> > I don't like pushing autocommit to the client.
> 
> It seems like a good idea to me, particularly since the current
> server-side implementation is such a kludge. Can you go over your
> objections to client-side autocommit again?

First, I am afraid a kludge on the server is going to become 10 client
kludges.  I also don't see how it can be easily controlled in the
application without adding an API function for every language --- adding
it to libpq will require new API's in perhaps 7 different languages.

I think our SET functionality is easy to understand and use.  I don't
see pushing it into the client as greatly improving things, and could
make things worse.  If we can't get it right in the backend, how many
clients are going to do it wrong?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: A bad behavior under autocommit off mode
Next
From: "Vadim Mikheev"
Date:
Subject: Re: Nested transactions: low level stuff