Re: Does RAISE EXCEPTION rollback previous commands in a stored function?

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: Does RAISE EXCEPTION rollback previous commands in a stored function?
Дата
Msg-id CAADeyWi3aeMH56KzzWcEXi=-u=hubRk3bPW5bJ0Qu16EM6U=XA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Does RAISE EXCEPTION rollback previous commands in a stored function?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Ответы Re: Does RAISE EXCEPTION rollback previous commands in a stored function?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Does RAISE EXCEPTION rollback previous commands in a stored function?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-general
Дерево обсуждения
Hi Laurenz,

how to set such a savepoint inside of a stored function?

Can I call "START TRANSACTION", and then at some point later in the same stored function call RAISE EXCEPTION?

Regargs
Alex

On Wed, Mar 2, 2016 at 10:37 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Andreas Kretschmer wrote:
>> Alexander Farber <alexander.farber@gmail.com> hat am 1. März 2016 um 19:41
>> geschrieben:
 
>> in PostgreSQL 9.5 does RAISE EXCEPTION reliably rollback all previous
>> commands in a stored function?
>
> Yes.

That is, unless you set a savepoint to which you can rollback.

В списке pgsql-general по дате отправления:

Предыдущее
От: Alexander Farber
Дата:
Сообщение: How to ensure that a stored function always returns TRUE or FALSE?
Следующее
От: Vitaly Burovoy
Дата:
Сообщение: Re: How to ensure that a stored function always returns TRUE or FALSE?