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: [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 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