Re: how to use SAVEPOINT in stored function

On 12/5/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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'd try to use a SAVEPOINT inside an SQL
function, it dumps below error:
ERROR: SAVEPOINT is not allowed in a SQL function
CONTEXT: SQL function "tmp_func" during startup
But we got below error message if we'd try the same in a pl/pgsql precedure:
ERROR: SPI_execute_plan failed executing query "SAVEPOINT svp0":
SPI_ERROR_TRANSACTION
CONTEXT: PL/pgSQL function "tmp_func" line 4 at SQL statement

Is it possible to make the latter error message some more informative
and user-friendly like the one in the previous?

Regards.