Re: [GENERAL] how to use savepoint and rollback in function

2011-03-16 Thread dhaval jaiswal
: Wed, 16 Mar 2011 10:55:23 +0530 Subject: [GENERAL] how to use savepoint and rollback in function From: tpneh...@gmail.com To: pgsql-general@postgresql.org Hi All, In Postgresql we can use savepoint and rollback to savepoint in transaction. But we cannot use savepoint in function. Currently I am

Re: [GENERAL] how to use savepoint and rollback in function

2011-03-16 Thread Alban Hertroys
On 16 Mar 2011, at 6:25, tushar nehete wrote: > Hi All, > In Postgresql we can use savepoint and rollback to savepoint in transaction. > But we cannot use savepoint in function. > Currently I am doing migration from Informix to Postgresql 8.4. > In Informix they used Savepoint. > Please advice how

[GENERAL] how to use savepoint and rollback in function

2011-03-15 Thread tushar nehete
Hi All, In Postgresql we can use savepoint and rollback to savepoint in transaction. But we cannot use savepoint in function. Currently I am doing migration from Informix to Postgresql 8.4. In Informix they used Savepoint. Please advice how to use Savepoint and rollback to savepoint in function. I