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

From Sergei Kornilov
Subject Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Date
Msg-id 859791535028081@myt4-906d9f8e7e5f.qloud-c.yandex.net
Whole thread Raw
In response to 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL  ("David Klika" <david.klika@atlas.cz>)
Responses Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
List pgsql-bugs
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

regards, Sergei


pgsql-bugs by date:

Previous
From: Tasos Maschalidis
Date:
Subject: Re: BUG #15347: Unaccent for greek characters does not work
Next
From: Pavel Stehule
Date:
Subject: Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL