SPI returns error for SAVEPOINT - Mailing list pgsql-general

From dandl
Subject SPI returns error for SAVEPOINT
Date
Msg-id 009c01d1b641$9a6a9220$cf3fb660$@andl.org
Whole thread Raw
Responses Re: SPI returns error for SAVEPOINT
List pgsql-general
A plandl (language handler for Andl) function is called as follows:

      BEGIN;
      SELECT plandl_compile($1); // argument is Andl code
      COMMIT;

Inside:

>SPI_exec("BEGIN",...) returns error SPI_ERROR_TRANSACTION. As expected.
>SPI_exec("SAVEPOINT xyz",...) returns error SPI_ERROR_TRANSACTION. Not
expected.

Is it not possible to set a SAVEPOINT inside a function? Or am I missing
something?

Regards
David M Bennett FACS

Andl - A New Database Language - andl.org




pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: 9.5 regression with unwanted nested loop left join
Next
From: Michael Paquier
Date:
Subject: Re: SPI returns error for SAVEPOINT