Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Дата
Msg-id CAFj8pRBBMRAD7GdGK6TV6DD8Ufn7heJ65xE6P0y8vjsAGDhLaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL  (Sergei Kornilov <sk@zsrv.org>)
Ответы Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-bugs


2018-08-23 14:41 GMT+02:00 Sergei Kornilov <sk@zsrv.org>:
Hello

> This routine works well on postgres v10:
it works? Or is only accepted as input? I got error on function call.
I thought plpgsql cannot directly uses savepoints, only implicitly with begin ... exception ... end block ( https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING )

Well, you can still create this function with set check_function_bodies to off

This doesn't help, because any function is validated before execution

Regards

Pavel

regards, Sergei


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

Предыдущее
От: Sergei Kornilov
Дата:
Сообщение: Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL