Barry Lind wrote:
>
>
> 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.
Oh, good point.
>
> >
> > 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.
-- 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