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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
