Re: BUG #14772: psql autocommit does not work

From: "alain bourgeois" <a(dot)bourgeois(at)zetescards(dot)be>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
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 08:14:11
Message-ID: OFFF917A86.8821C4A3-ONC1258176.002D1147-C1258176.002D3EBC@LocalDomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

testdb=# \set autocommit off;
testdb=# insert into tabtest(id, texte) values (3,'test');
INSERT 0 1
testdb=# commit;
ATTENTION: aucune transaction en cours
COMMIT

OK I found : \set AUTOCOMMIT false
(without any semicolumn)

Alain Bourgeois
Software Engineer
Tel: +32 (0)2 333 49 20
Mobile: +32 (0)496 51 85 75
skype: abozetes
ZETES PASS, division of ZETES SA/NV
Disclaimer : This e-mail may contain material that is confidential and
privileged for the sole use of the intended recipient. Any review,
reliance or distribution by others or forwarding without express
permission is strictly prohibited and may be unlawful. If you receive this
message in error, please contact the sender and delete the material from
any computer.

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: abo(at)zetescards(dot)be
Cc: PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org>
Date: 07-08-17 16:32
Subject: Re: [BUGS] BUG #14772: psql autocommit does not work

> testdb=# set autocommit=off;
> ERREUR: paramètre de configuration « autocommit » non reconnu

Sure, there is no "autocommit" server-side setting.

You meant the client-side setting: psql> \set AUTOCOMMIT off

--
Fabien.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hillel Eilat 2017-08-08 08:34:22 Re: BUG #14771: "Logical decoding" does not cover the impact of "TRUNCATE TABLE" command
Previous Message Jaimin Pan 2017-08-08 06:53:43 Re: Error of insert Foreign table with postgres_fdw