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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Sergei Kornilov <sk(at)zsrv(dot)org>
Cc: David Klika <david(dot)klika(at)atlas(dot)cz>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Date: 2018-08-23 13:00:47
Message-ID: CAFj8pRBBMRAD7GdGK6TV6DD8Ufn7heJ65xE6P0y8vjsAGDhLaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

2018-08-23 14:41 GMT+02:00 Sergei Kornilov <sk(at)zsrv(dot)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
>
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2018-08-23 13:04:59 Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL
Previous Message Sergei Kornilov 2018-08-23 12:41:21 Re: 11 beta 3 / ROLLBACK TO SAVEPOINT regression in PLPGSQL