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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Дата
Msg-id CAFj8pRAhiDSf8ESa1sd3XhzTta1hGPriDVPzaMN2Nvh8nQMkvw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы RE: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL  ("David Klika" <david.klika@atlas.cz>)
Список pgsql-bugs


2018-08-23 15:00 GMT+02:00 Pavel Stehule <pavel.stehule@gmail.com>:


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

but it is hard to believe, so it was working ever.



Regards

Pavel

regards, Sergei



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

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