On 12/5/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> In plpgsql, you're supposed to use exception blocks instead.
AFAIC, SAVEPOINT usage isn't permitted in any procedural language. But
it also isn't documented. (I couldn't find any phrase mentioning about
this in the docs.)
One more question, if we'
[EMAIL PROTECTED] writes:
> I would like using savepoints in my stored functions but I always get the
> error
> ERROR: SPI_execute_plan failed executing query "SAVEPOINT my_savepoint":
In plpgsql, you're supposed to use exception blocks instead. See
http://www.postgresql.org/docs/8.1/static/pl
Hi community,
I would like using savepoints in my stored functions but I always get the
error
ERROR: SPI_execute_plan failed executing query "SAVEPOINT my_savepoint":
SPI_ERROR_TRANSACTION
CONTEXT: PL/pgSQL function "savepoint_test" line 3 at SQL statement
My test function can be found below
Hi community,
I would like using savepoints in my
stored functions but I always get the error
ERROR: SPI_execute_plan
failed executing query "SAVEPOINT my_savepoint": SPI_ERROR_TRANSACTION
CONTEXT: PL/pgSQL function
"savepoint_test" line 3 at SQL statement
My test function can be found below.
