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
--
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
