On Dec 20, 2012, at 3:40 PM, Rob Sargent <robjsargent@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*.
Turns out someone put a .psqlrc with autocommit off in /etc/skel when the box was originally set up as a replacement
forour previous app server. Account users were created afterwards, and the change propagated to our application account
aswell 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
configfile manage to do it?
Thanks for the insight!
--
Stephen Touset
Senior Software Engineer
stephen.touset@onelogin.com