how to use savepoint and rollback in function

[tushar nehete <tpnehete@xxxxxxxxx>]

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.

 

Thanks & Regards,

Tushar