Re: [GENERAL] how to use SAVEPOINT in stored function

2005-12-05 Thread Volkan YAZICI
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'

Re: [GENERAL] how to use SAVEPOINT in stored function

2005-12-05 Thread Tom Lane
[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