Re: Reg:Autocommit

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)*

I want the permanent solution without using "BEGIN".
Can you please tell me the solution.

Thanks & Regards,
Neeraj.

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

> On Saturday, July 25, 2015, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
> wrote:
>
>> On Friday, July 24, 2015, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
>> wrote:
>>
>>> Hi All,
>>>
>>> Sorry for keeping Repeat mail, I didn't mention the Error what i am
>>> getting
>>>
>>> This is the Error mentioned below.
>>> * postgres=#*
>>> *set autocommit to off; ERROR: SET AUTOCOMMIT TO OFF is no longer
>>> supported*
>>> * postgres=#*
>>>
>>>
>>
>> Try: "BEGIN;"
>>
>>
> Or you can use the psql specific:
>
> \set AUTOCOMMIT off
>
> Auto-commit is a feature of the client, not the server.
>
> David J.
>