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

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

Regards

Pavel

>
> regards, Sergei
>
>