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