Re: Reg:Autocommit
| От | Raghavendra |
|---|---|
| Тема | Re: Reg:Autocommit |
| Дата | |
| Msg-id | CA+h6AhjEbYYzG-ZH1hX6wnP2oREtvDQ9S=VjsOOCxF+oMfgAcg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Reg:Autocommit ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: Reg:Autocommit
|
| Список | pgsql-admin |
On Saturday, July 25, 2015, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:I tried it but the "autocommit" is showing "on" as mention below.Hi David ,Thanks for reply,
postgres=# \set autocommit off;postgres=# show autocommit;
autocommit
------------
on
(1 row)The first command sets a psql variable named autocommit.The second commands show the sql guc named autocommit.These are two different things.Try "select :AUTOCOMMIT"Note, in the psql variable capitalization matters. You must use all-caps.David J.
+1
You can try this to check out what setting is set in psql variable.
-bash-4.2$ psql
psql.bin (9.4.4)
Type "help" for help.
postgres=# \set AUTOCOMMIT off
postgres=# \echo :AUTOCOMMIT
off
postgres=# \set AUTOCOMMIT on
postgres=# \echo :AUTOCOMMIT
on
postgres=#
---
Regards,
Raghavendra
EnterpriseDB Corporation
В списке pgsql-admin по дате отправления: