Re: How to disable auto-commit in postgresql-9.4

From: amul sul <sul_amul(at)yahoo(dot)co(dot)in>
To: Nirban Sen <sennirban89(at)gmail(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>, "pgsql-genera(at)postgresql(dot)org" <pgsql-genera(at)postgresql(dot)org>
Subject: Re: How to disable auto-commit in postgresql-9.4
Date: 2015-04-21 10:38:33
Message-ID: 1450284155.846924.1429612713768.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

If you are using psql as client, simply add the following line to ~/.psqlrc:

\set AUTOCOMMIT off


Regards,
Amul Sul

On Tuesday, 21 April 2015 2:11 PM, Nirban Sen <sennirban89(at)gmail(dot)com> 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.

--

With Best Regards,,
Nirban Sen
+91-9614612152

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message JORGE MALDONADO 2015-04-23 11:17:42 Getting the current value of a sequence
Previous Message Albe Laurenz 2015-04-21 09:30:34 Re: How to disable auto-commit in postgresql-9.4