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