Postgres Pro
Downloads
Home   >   mailing lists

Re: Reg:Autocommit - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Reg:Autocommit
Date
Msg-id CAGDYbUPwre0+tGbXtfq+oYmcoHRzL=7dH+PbWH8273JqmBEeoA@mail.gmail.com
Whole thread Raw
In response to Reg:Autocommit  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Reg:Autocommit  (Scott Ribe <scott_ribe@elevated-dev.com>)
Re: Reg:Autocommit  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
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@gmail.com> wrote:
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: "Greg Sabino Mullane"
Date:
Subject: Re: Error in getting top 10 biggest table
Next
From: Scott Ribe
Date:
Subject: Re: Reg:Autocommit