Postgres Pro
Downloads
Home   >   mailing lists

Re: set AUTOCOMMIT OFF in psqlrc not having affect - Mailing list pgsql-admin

From Tom Lane
Subject Re: set AUTOCOMMIT OFF in psqlrc not having affect
Date
Msg-id 10223.1098041905@sss.pgh.pa.us
Whole thread Raw
In response to set AUTOCOMMIT OFF in psqlrc not having affect  (Christian Fowler <spider@viovio.com>)
Responses Re: set AUTOCOMMIT OFF in psqlrc not having affect  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Tree view 
Christian Fowler <spider@viovio.com> writes:
> I have \set AUTOCOMMIT OFF in my .psqlrc and it seems psql seems to not
> have any effect.

I think the value is case-sensitive.  Try
    \set AUTOCOMMIT off

            regards, tom lane

pgsql-admin by date:

Previous
From: Christian Fowler
Date:
Subject: set AUTOCOMMIT OFF in psqlrc not having affect
Next
From: Bruce Momjian
Date:
Subject: Re: set AUTOCOMMIT OFF in psqlrc not having affect