RE: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
David Klika <david.klika@atlas.cz>
From: "David Klika" <david.klika@atlas.cz>
To: "'Pavel Stehule'" <pavel.stehule@gmail.com>, "'Sergei Kornilov'" <sk@zsrv.org>
Cc: <pgsql-bugs@postgresql.org>
Date: 2018-08-23T14:45:02Z
Lists: 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