Re: Reg: PL/pgSQL commit and rollback

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: Reg: PL/pgSQL commit and rollback
Дата
Msg-id CAF-3MvNd2K3ted6D16EKgJQi0uBrK9WXDr_hjis0iNu9XdEKDw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reg: PL/pgSQL commit and rollback  (Medhavi Mahansaria <medhavi.mahansaria@tcs.com>)
Список 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 по дате отправления:

Предыдущее
От: Medhavi Mahansaria
Дата:
Сообщение: Re: Reg: PL/pgSQL commit and rollback
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Reg: PL/pgSQL commit and rollback