On Thu, Dec 20, 2012 at 7:04 PM, Stephen Touset <stephen.tou...@onelogin.com> wrote: > On Dec 20, 2012, at 3:40 PM, Rob Sargent <robjsarg...@gmail.com> wrote: > >> On 12/20/2012 04:33 PM, Stephen Touset wrote: >> >>> So yes, AUTOCOMMIT is definitely on. >> >> What does \set show when entered from the psql command line? > > test=> \set > AUTOCOMMIT = 'OFF' > > *facepalm*.
\set is a psql command > Turns out someone put a .psqlrc with autocommit off in /etc/skel when the box > was originally set up as a replacement for our previous app server. Account > users were created afterwards, and the change propagated to our application > account as well as all of our individual accounts. > > Why, though, would `SHOW AUTOCOMMIT` lie? And `SET AUTOCOMMIT TO off` says > that capability is disabled. So how does the config file manage to do it? show variable is a SQL command to the backend engine. The backend does not support autocommit on / off (it did once upon a time for a little while but it broke lots of stuff and got reverted). autocommit is now firmly a client side behavior, not a backend behavior. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
