SPI returns error for SAVEPOINT

From: "dandl" <david(at)andl(dot)org>
To:
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: SPI returns error for SAVEPOINT
Date: 2016-05-25 04:55:02
Message-ID: 009c01d1b641$9a6a9220$cf3fb660$@andl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2016-05-25 05:22:01 Re: SPI returns error for SAVEPOINT
Previous Message Greg Sabino Mullane 2016-05-25 03:07:41 Re: 9.5 regression with unwanted nested loop left join