On Jul 25, 2015, at 7:22 AM, Shreeyansh Dba <shreeyansh2014@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ https://www.linkedin.com/in/scottribe/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin