Re: rollback to savepoint issue

On Monday, September 4, 2023, Erik Wienhold <ewie(at)ewie(dot)name> wrote:

> On 04/09/2023 11:51 CEST Lorusso Domenico <domenico(dot)l76(at)gmail(dot)com> wrote:
>
> > I can't use the savepoint and rollback to savepoint clause.
> > I've found some similar problems around on the web, but I can't catch the
> > good way to proceed.
> >
> > What I'm trying to do is:
> > * compare new set of attribute with older
> > * if some attributes are part of old set and not in the new one: delete
> > the old
> > * but if parameter "on_misisng_delete" is false rollback delete command
> > and rais exception
> > The original code in embedded in a function, but the problem is the same:
>
> Transaction control is not possible in functions. Only in procedures
> (CALL)
> and DO blocks.
>

Then explain why the original savepoint command wasn’t a syntax, or
runtime, error? Plus, the error is syntax, usually when you try something
that exists but is disallowed the system gives you some kind of invalid
state exception at runtime,

David J.