Re: BUG #14772: psql autocommit does not work

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: alain bourgeois <a(dot)bourgeois(at)zetescards(dot)be>
Cc: abo(at)zetescards(dot)be, PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14772: psql autocommit does not work
Date: 2017-08-08 16:32:15
Message-ID: alpine.DEB.2.20.1708081829200.10425@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


> also, the semicolumn, needed for some statementds (sql) but not all.

Yes, it is pretty strange.

The backslash command are outside of SQL and finished on the line. You can
use them anywhere:

psql> SELECT
\set x 2
1
\set y 3
;
# 1
psql> \echo :x :y
# 2 3

Basically SQL & backslash commands are unrelated. The SQL is sent to the
server, the backslash is executed on the client...

--
Fabien.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Hillel Eilat 2017-08-08 16:50:25 ODBC setup of "Level of rollback on errors" is not settable at run time
Previous Message alain bourgeois 2017-08-08 13:23:00 Re: BUG #14772: psql autocommit does not work