On Tue, Mar 18, 2003 at 05:18:02PM -0500, Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > Bruce Momjian writes:
> >
> > > What if folks want all their connections autocommit off.
> >
> > For interactive use, people can record their preferred setting in
> > ~/.psqlrc or something like that.
>
> But that only works for psql, right? How would this be done at the
> libpq level? Environment variables? GUC seems a whole lot cleaner.
I think an environment variable would be right. The current method is
not clean in the sense that a client cannot decide what she wants; she
just accepts the decision from the DBA. Thus, an application can't be
written with a certain value in mind, because the DBA can change the
setting at any time.
Client-side decision is the wiser proposal, I think.
> I understand. I just don't see any value in pushing that logic into
> each client when we can do it centrally in the server.
The server doesn't know beforehand what the client wants.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No renuncies a nada. No te aferres a nada"