Re: Reg:Autocommit

[Shreeyansh Dba <shreeyansh2014@xxxxxxxxx>]

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.g.johnston@xxxxxxxxx> wrote:

On Saturday, July 25, 2015, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Friday, July 24, 2015, Shreeyansh Dba <shreeyansh2014@xxxxxxxxx> 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.