Re: Postgres config file: autocommit = off

I agree with you, but as outvoted by the group --- can someone give the
the client-side argument for him.  I know it, but my heart isn't in it. :-)

---------------------------------------------------------------------------

Rasmus Resen Amossen wrote:
> >One of the reasons for taking autocommit control out of the backend and
> >pushing it up to the client level is exactly to make it feasible to take
> >these sorts of application-level considerations into account when
> >choosing the behavior.
> 
> Ok, I can see some sense in that: Make the autocommit-behavior client 
> dependent instead of system dependent. But that requires that all clients 
> the user uses can handle this (is able to store a default behavior).
> I aggree, that clients should, as you write, overrule the system default 
> behavior. But I (still) can't find an argument for, why the administrator 
> should not have the oppotunity to set a default behavior for the whole 
> system (not even in the archives). In this way postgres would be able to 
> deal with clients that did not have support for setting the default 
> behavior. Eventually a per user or per database default behavior could be 
> usefull for the same resons.
> 
> Bennefits:
>    - Project managers can easier force programmers to use a specific 
> database coding style. Fx.: I guess that if the PHP-interface should have a 
> default value it should be given at the connect time. Programmers could 
> easily forget to set "autocommit = off" here, thus allowing them self an 
> eventually unwanted coding style.
>    - Clinents which do not support setting an autocommit default behavior, 
> can be used by setting the wanted behavior for the database system.
> 
> Drawbacks:
>    - ? (Enlighten me)
> 
> _________________________________________________________________
> Send s�de postkort til s�de mennesker http://www.msn.dk/postkort
> 
> 

--  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