Re: [GENERAL] "\set AUTOCOMMIT off" has affect

2006-03-19 Thread Axel Straschil
Hallo! > It is. You're just looking at the no-op GUC variable instead of the > psql one. Try > \echo :AUTOCOMMIT > instead. Oh, your right, just tested, it is ;-) Thanks, AXEL. ---(end of broadcast)--- TIP 3: Have you checked our extensive FA

Re: [GENERAL] "\set AUTOCOMMIT off" has affect

2006-03-19 Thread Andreas Seltenreich
Axel Straschil writes: > I want to disable autocommit, my psqlrc: > > SET client_min_messages = 'WARNING'; > SET add_missing_from = false; > \set AUTOCOMMIT off > > it has no effect: > > echo "show AUTOCOMMIT" | psql > SET > SET > autocommit > > on > (1 row) > > How can I disable a

[GENERAL] "\set AUTOCOMMIT off" has affect

2006-03-19 Thread Axel Straschil
Hello! I want to disable autocommit, my psqlrc: SET client_min_messages = 'WARNING'; SET add_missing_from = false; \set AUTOCOMMIT off it has no effect: echo "show AUTOCOMMIT" | psql SET SET autocommit on (1 row) How can I disable autocommit in psqlrc? Thanks, Axel.