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

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


2018-08-23 16:45 GMT+02:00 David Klika <david.klika@atlas.cz>:


> 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


No problem :)

Pavel

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

Предыдущее
От: "David Klika"
Дата:
Сообщение: RE: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15342: pg_dump - XML with mixed content types generates invalid backup file