Re: [GENERAL] SPI returns error for SAVEPOINT

2016-05-24 Thread dandl
> >>SPI_exec("BEGIN",...) returns error SPI_ERROR_TRANSACTION. As expected. > >>SPI_exec("SAVEPOINT xyz",...) returns error SPI_ERROR_TRANSACTION. Not > > expected. > > The docs say that this is expected: > https://www.postgresql.org/docs/devel/static/spi-spi-execute.html > SPI_ERROR_TRANSACTION >

Re: [GENERAL] SPI returns error for SAVEPOINT

2016-05-24 Thread Michael Paquier
On Tue, May 24, 2016 at 9:55 PM, dandl wrote: > 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. >

[GENERAL] SPI returns error for SAVEPOINT

2016-05-24 Thread dandl
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_TRANSAC