From: | "Rasmus Resen Amossen" <rresena(at)hotmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Postgres config file: autocommit = off |
Date: | 2003-05-31 11:34:49 |
Message-ID: | Law14-F111CLHBBoGGw000233e7@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I'm not sure that this is the right list to ask - but after having googled a
while it seems that the only ones that might be able to answer this question
is the developers. Therefor, here we go:
As far as I have understood, postgres is autocommiting each typed statement
UNLESS the user remembers to write "BEGIN" which then disables the
autocommit behavior for this single transaction. -Unfortunately it's easy to
forget the BEGIN and it might be quite troublesome if one has to do it a
lot.
Therefor: Are there any plans to give the administrator an OPTION to turn
the behavior off through a parameter "autocommit = <boolean>" in the config
file? Eventually the default behavior could be the autoccomit = on, as it is
now.
Eventually an option per database could override the config file setting, so
that the default value was to disable the autocommit behavior but a subset
of the databases had autocommit enabled.
_________________________________________________________________
F MSN Hotmail p mobilen http://www.msn.dk/mobile
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-05-31 15:25:07 | Re: default locale considered harmful? (was Re: [GENERAL] |
Previous Message | Peter Eisentraut | 2003-05-31 11:24:50 | Re: default locale considered harmful? (was Re: [GENERAL] |