Re: how to use savepoint and rollback in function

[dhaval jaiswal <dhavallj@xxxxxxxxxxx>]

 
 
 
create table mock (id int);
begin;
truncate table mock;
insert into mock values (1),(2);
savepoint A;
insert into mock values (3),(4);
savepoint B;
rollback to savepoint A;
end;
 
Following link may help you.
http://www.postgresql.org/docs/current/static/sql-rollback-to.html 

 

---

Date: Wed, 16 Mar 2011 10:55:23 +0530
Subject: how to use savepoint and rollback in function
From: tpnehete@xxxxxxxxx
To: pgsql-general@xxxxxxxxxxxxxx

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