Postgres Pro
Downloads
Home   >   mailing lists

"\set AUTOCOMMIT off" has affect - Mailing list pgsql-general

From Axel Straschil
Subject "\set AUTOCOMMIT off" has affect
Date
Msg-id slrne1q9oc.8f6.axel@m2.sine
Whole thread Raw
Responses Re: "\set AUTOCOMMIT off" has affect  (Andreas Seltenreich <andreas+pg@gate450.dyndns.org>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "Alex bahdushka"
Date:
Subject: PANIC: heap_update_redo: no block
Next
From: Martijn van Oosterhout
Date:
Subject: Re: PANIC: heap_update_redo: no block