Postgres Pro
Downloads
Home   >   mailing lists

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 CAFj8pRBBMRAD7GdGK6TV6DD8Ufn7heJ65xE6P0y8vjsAGDhLaQ@mail.gmail.com
Whole thread Raw
In response to Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL  (Sergei Kornilov <sk@zsrv.org>)
Responses Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
List pgsql-bugs
Tree view


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


pgsql-bugs by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Next
From: Pavel Stehule
Date:
Subject: Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL