On 17 March 2015 at 15:30, Medhavi Mahansaria <medhavi.mahansaria@xxxxxxx> wrote: > Yes. I have read this document. > > But my issue is that even when it throws and exception I need to rollback > the changes made by that query and move on to the next block. > > Is there any way to accomplish that? Please do not toppost on this list. The solution is to do what Albe explained: use BEGIN ... EXCEPTION ... -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general