Re: "\set AUTOCOMMIT off" has affect

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