Re: Postgres config file: autocommit = off

>We have been there, done that, and decided it was a bad idea. I suggest
>you do a little reading in the mail list archives.

I have searched the lists archives for the words "commit", "autocommit" and
"transaction" but couldn't find any discussion on wheter to give a database
administrator the option to turn automatic commit off was is a good idea or
not (not requirering the user to enter BEGIN; to start a transaction).

Do you know the title of the thread or some more details on where to find
the arguments? I look forward to read that discussion. :-)

Personally I am managing a database for approx. 500 people which are all
VERY dependant on the correctnes of the database. Sometimes, when we do
manually fixes in the database, it takes a series of statements before our
data mangeling leaves the databases in a consistent state again. Therefor it
is a quite serious problem for us if we forget the BEGIN-word (which happens
quite often :-( ), so we could really use the config file option mentioned.

Regards, Rasmus

_________________________________________________________________
Tag MSN Hotmail med dig p mobilen http://www.msn.dk/mobile