On Wed, Mar 7, 2012 at 9:25 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > In psql, see "\set AUTOCOMMIT off". In other frontends, it would depend > on the client-side code whether or how you can do that. > > (We once made an attempt to provide this sort of behavioral option on > the server side; but it was a complete disaster from the client > compatibility standpoint, and was soon, um, rolled back.) I'm talking about using the application-level protocols (eg the pg_* functions in PHP), so it's your second option. And yeah, I see your point. Major compat issues. Well, at least the libpqxx library can solve that one! ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general