"Jaiswal Dhaval Sudhirkumar" <JaiswalDS(at)microland(dot)com> writes:
> ERROR: SPI_execute_plan_with_paramlist failed executing query "SAVEPOINT my_savepoint": SPI_ERROR_TRANSACTION
This is not a bug. It's an extremely well-documented limitation that
you can't use those commands in a plpgsql function.
You can get the effect of a savepoint using a BEGIN/EXCEPTION block.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Piergiorgio Buongiovanni||Date: 2011-02-18 15:47:24|
|Subject: BUG #5894: Rules' behaviour when SERIAL data types are used|
|Previous:||From: Euler Taveira de Oliveira||Date: 2011-02-18 13:26:01|
|Subject: Re: BUG #5878: BTREE_BUILD_STATS causes 'make check' to fail|