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.
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 autocommit in psqlrc?
It is. You're just looking at the no-op GUC variable instead of the
psql one. Try
\echo :AUTOCOMMIT
instead.
regards,
andreas
--
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.