Re: [INTERFACES] Roadmap for FE/BE protocol redesign - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [INTERFACES] Roadmap for FE/BE protocol redesign
Date
Msg-id Pine.LNX.4.44.0303181551230.3331-100000@peter.localdomain
Whole thread Raw
In response to Re: [INTERFACES] Roadmap for FE/BE protocol redesign  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [INTERFACES] Roadmap for FE/BE protocol redesign
List pgsql-hackers
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 any non-interactive program is written with a specific autocommit
setting in mind.  Either it assumes that single statements are
automatically committed or it issues explicit COMMIT commands.  That
means, the choice of autocommit mode is always ultimately determined by
the client, never by the server or its administrator.

For that very reason most standard interfaces define in their
specification whether applications must assume autocommit behavior or must
not do so.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Nested transactions
Next
From: Peter Eisentraut
Date:
Subject: Re: anyone? CREATELANG in pgsql 7.3.2 failing