Re: Reg:Autocommit - Mailing list pgsql-admin

On Sat, Jul 25, 2015 at 8:14 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Saturday, July 25, 2015, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:

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)

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

Blog: http://raghavt.blogspot.com/