Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Sergei Kornilov <sk@zsrv.org>
Cc: David Klika <david.klika@atlas.cz>, "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>
Date: 2018-08-23T13:04:59Z
Lists: pgsql-bugs
2018-08-23 15:00 GMT+02:00 Pavel Stehule <pavel.stehule@gmail.com>: > > > 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/doc >> s/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. > Regards > > Pavel > >> >> regards, Sergei >> >> >