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

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