Re: Reg:Autocommit - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Reg:Autocommit
Date
Msg-id B0B21EAF-A138-43E6-A336-706EA7FD7ED9@elevated-dev.com
Whole thread Raw
In response to Re: Reg:Autocommit  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
On Jul 25, 2015, at 7:22 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
>
> I want the permanent solution without using "BEGIN".
> Can you please tell me the solution.

The permanent solution is to specify the boundaries of your transactions, using begin & commit. It's either that, or
letyour client assume that every submitted statement should be its own transaction, which is what autocommit does. 


--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: Reg:Autocommit
Next
From: "David G. Johnston"
Date:
Subject: Re: Reg:Autocommit