Thread: "\set AUTOCOMMIT off" has affect

"\set AUTOCOMMIT off" has affect

From
Axel Straschil
Date:
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.

Re: "\set AUTOCOMMIT off" has affect

From
Andreas Seltenreich
Date:
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
--

Re: "\set AUTOCOMMIT off" has affect

From
Axel Straschil
Date:
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.