Re: A bad behavior under autocommit off mode

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Barry Lind <blind(at)xythos(dot)com>, Neil Conway <neilc(at)samurai(dot)com>, Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: A bad behavior under autocommit off mode
Date: 2003-03-22 17:39:26
Message-ID: 1639.1048354766@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> I'm not sure they need these parameters to be *unchangeable*. What they
>> need is to *know what they are*, with certainty. The notion of issuing
>> an automatic report message whenever the values change would seem to
>> answer that.

> What concerns me also about the reporting problem is that some of these
> interfaces must issue queries in several places in the code, so somehow
> they have to make sure they check for those _special_ values in all
> those places.

Not sure what your point is here. If an interface is going to support
more than one value of a parameter, then yes it has to be sure to do the
right thing in each affected place. There's no shortcut for that.

> Also, with autocommit, is the idea for autocommit logic to be in the
> clients, or just control of autocommit to be in the clients, with the
> logic still being in the server?

My thought is to put it in the clients. All except libpq already have
some such logic, and it worked well enough except for their inability to
be completely sure of the backend's state --- which we will fix with the
protocol revision. The server-side implementation has turned out to be
a complete mess.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-03-22 17:48:25 Re: A bad behavior under autocommit off mode
Previous Message Bruce Momjian 2003-03-22 17:26:44 Re: A bad behavior under autocommit off mode