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 to use Savepoint and rollback to savepoint in function.
> I know Postgresql has autocommit. But I want to rollback to a particular savepoint.
Within functions you can use exceptions with begin/end blocks to get the same behaviour as savepoints and rollbacks.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4d806b00235886291739995!