Re: A bad behavior under autocommit off mode

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