Re: Reg:Autocommit

On Sat, Jul 25, 2015 at 8:14 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Saturday, July 25, 2015, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
> wrote:
>
>> Hi David ,
>> Thanks for reply,
>> I tried it but the "autocommit" is showing "on" as mention below.
>>
>> *postgres=# \set autocommit off;*
>>
>>
>>
>>
>>
>> *postgres=# show autocommit; autocommit------------ on(1 row)*
>>
>
> The first command sets a psql variable named autocommit.
> The second commands show the sql guc named autocommit.
> These are two different things.
> Try "select :AUTOCOMMIT"
> Note, in the psql variable capitalization matters. You must use all-caps.
>
> David J.
>>
>>
​+1

You can try this to check out what setting is set in psql variable.

-bash-4.2$ psql
psql.bin (9.4.4)
Type "help" for help.

postgres=# \set AUTOCOMMIT off
postgres=# \echo :AUTOCOMMIT
off
postgres=# \set AUTOCOMMIT on
postgres=# \echo :AUTOCOMMIT
on
postgres=#
​
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/