Re: Reg: PL/pgSQL commit and rollback - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Reg: PL/pgSQL commit and rollback
Date
Msg-id CAF-3MvNd2K3ted6D16EKgJQi0uBrK9WXDr_hjis0iNu9XdEKDw@mail.gmail.com
Whole thread Raw
In response to Re: Reg: PL/pgSQL commit and rollback  (Medhavi Mahansaria <medhavi.mahansaria@tcs.com>)
List pgsql-general
On 17 March 2015 at 15:30, Medhavi Mahansaria
<medhavi.mahansaria@tcs.com> 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 ...


pgsql-general by date:

Previous
From: Medhavi Mahansaria
Date:
Subject: Re: Reg: PL/pgSQL commit and rollback
Next
From: Adrian Klaver
Date:
Subject: Re: Reg: PL/pgSQL commit and rollback