Re: Reg:Autocommit

Hi Raghavendra,

Thank you for the solution, It is working fine.

Thanks & Regards
Neeraj

On Mon, Jul 27, 2015 at 12:33 PM, Raghavendra <
raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:

> 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/
>