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

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


> 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.

 

 

You are right, calling the method lead to error in both cases. My misunderstanding, sorry. David

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

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