| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Reg:Autocommit |
| Date: | 2015-07-25 13:29:45 |
| Message-ID: | B0B21EAF-A138-43E6-A336-706EA7FD7ED9@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Jul 25, 2015, at 7:22 AM, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)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 let your client assume that every submitted statement should be its own transaction, which is what autocommit does.
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2015-07-25 14:44:43 | Re: Reg:Autocommit |
| Previous Message | Shreeyansh Dba | 2015-07-25 13:22:15 | Re: Reg:Autocommit |