> To ease any pain, what about a configuration setting for the build > script for postgres (and psql) which changes the default behaviour for > the AUTOCOMMIT setting.
I really agree on the need for a posibility to set autocommit = off *regardless* of the client: On a system using both psql, php and perl on a large bunch of clients it is a pain - real pain - to set this behavior up individually. It could be really nice if I had a choise of ensuring that any default behavior was the more "secure" autommit = off. So please bring back this setting in postgresql.conf. Please. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html