Postgres Pro
Downloads
Home   >   mailing lists

Re: Reg:Autocommit - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Reg:Autocommit
Date
Msg-id CAGDYbUOB_Pec7TZYfSOuKLwwsB7CNU5dqtqo5f7KhMiaFJVOWQ@mail.gmail.com
Whole thread Raw
In response to Reg:Autocommit  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Responses Re: Reg:Autocommit  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
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=#
 
Can u help me, Is their any option to "Autocommit to keep off " in PostgreSQL9.4,
Anyhow By default "autocommit is on".

So i need to keep autocommit off, can anyone guide me to keep the "autocommit=off".

Thanks & Regards,
Neeraj.

On Sat, Jul 25, 2015 at 11:21 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
Hi All,

Can u help me, Is their any option to "Autocommit to keep off " in PostgreSQL
Any how By default "autocommit is on"

So i need to keep autocommit off, can anyone guide me to keep the "autocommit=off"

Thanks & Regards,
 Neeraj

pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Reg:Autocommit
Next
From: Ankur Kaushik
Date:
Subject: Error in getting top 10 biggest table