Reg:Autocommit - Mailing list pgsql-admin

From David G. Johnston
Subject Reg:Autocommit
Date
Msg-id CAKFQuwZeBpcxTnwiiwMg2Zjd5RDSa0NVscOJGgzLHNKS8Eagsg@mail.gmail.com
Whole thread Raw
In response to Re: Reg:Autocommit  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Reg:Autocommit  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
On Saturday, July 25, 2015, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Friday, July 24, 2015, Shreeyansh Dba <shreeyansh2014@gmail.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.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Reg:Autocommit
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Error in getting top 10 biggest table