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.
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 |