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
I am running postgres 8.1.2 on both a windows and Linux platform.
The primary method of managing business logic is through the use of
functions. Our primary access to the database is by using PSQL (pg/psql).
The problem that I am having is that we need to execute and implement
"SAVEPOINT" an
