Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Date
Msg-id CAFj8pRAhiDSf8ESa1sd3XhzTta1hGPriDVPzaMN2Nvh8nQMkvw@mail.gmail.com
Whole thread Raw
In response to Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses RE: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
List 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/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.



Regards

Pavel

regards, Sergei



pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Next
From: Tom Lane
Date:
Subject: Re: Not found indexed word