Re: Reg:Autocommit

Поиск
Список
Период
Сортировка
От Shreeyansh Dba
Тема Re: Reg:Autocommit
Дата
Msg-id CAGDYbUPwre0+tGbXtfq+oYmcoHRzL=7dH+PbWH8273JqmBEeoA@mail.gmail.com
обсуждение исходный текст
Ответ на Reg:Autocommit  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Reg:Autocommit
Re: Reg:Autocommit
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: Error in getting top 10 biggest table
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: Reg:Autocommit