Re: How to disable auto-commit in postgresql-9.4 - Mailing list pgsql-novice

Nirban Sen wrote:
> I am using postgresql-9.4 ,but not able to disable auto-commit.So I tried to disable it using SET
> AUTOCOMMIT { = | TO } { ON | OFF } but it no twork.
> I will be grateful if you let me know as soon as possible.

The last PostgreSQL server version that had such a feature was 7.3.

Ever since, you cannot disable autocommit in PostgreSQL.

However, psql has such a feature which you can enable by
   \set AUTOCOMMIT off
With that, psql will emulate "autocommit off" by automatically issuing
BEGIN before any statement if no transaction is already open.

Yours,
Laurenz Albe