Scott Petersen wrote:
Hi,
> Question 1: does pg/psql functions allow "SAVEPOINT/ROLLBACK"
> functionality? (if so how?)
Yes. However, you cannot use that syntax directly. You rather use it
by establishing EXCEPTION clauses in BEGIN/END blocks. Upon entering
any BEGIN/END block which has an EXCEPTION clause, an implicit SAVEPOINT
is executed. If any exception (read: error) is found while executing
the block, the savepoint will be automatically rolled back and control
passed to the EXCEPTION block.
HTH,
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.