From: Barry Lind <blind@xythos.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: Alvaro Herrera <alvherre@dcc.uchile.cl>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Re: [INTERFACES] Roadmap for FE/BE protocol redesign
Date: Fri, 21 Mar 2003 15:28:03 -0800
Message-ID: <3E7BA003.9070501@xythos.com> (raw)
In-Reply-To: <200303212252.h2LMqsF20161@candle.pha.pa.us>
References: <200303212252.h2LMqsF20161@candle.pha.pa.us>
Bruce Momjian wrote:
> I was thinking if we had a SET PERMANENT that couldn't be changed,
> interfaces that want to control variables could set them perminantly,
> and others could let users control it.
SET PERMANENT only works for those variables that can only have one
value for a given client protocol (for example datestyle in jdbc).
Whereas autocommit needs to be changeable by the jdbc driver since the
jdbc spec allows the user to call an API method to change the setting.
>
> Actually, if we reported change to the client, the interface could
> override any change the user made --- just an idea.
Reporting the change to the client seems sufficient for the client to
take whatever actions are necessary.
--Barry
>
> ---------------------------------------------------------------------------
>
> Tom Lane wrote:
>
>>Bruce Momjian <pgman@candle.pha.pa.us> writes:
>>
>>>Man, I lost another vote! :-)
>>
>>Happens to us all ;-)
>>
>>But this discussion is far from over ... not that many people have
>>weighed in yet. Also, even if autocommit's fate is sealed, we still
>>have to think about how to handle the other variables Barry identified
>>as trouble spots.
>>
>> regards, tom lane
>>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: blind@xythos.com, pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us, peter_e@gmx.net, alvherre@dcc.uchile.cl, pgsql-hackers@postgresql.org
Subject: Re: [INTERFACES] Roadmap for FE/BE protocol redesign
In-Reply-To: <3E7BA003.9070501@xythos.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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