Dennis Brakhane escribió: > On Wed, Oct 1, 2008 at 5:54 PM, Reg Me Please <[EMAIL PROTECTED]> wrote: > > Hi all. > > > > Is there a way to have (sub)transactions within a function body? > > I'd like to execute some code (a transaction!) inside a function and later > > decide whether that transaction is to be committed or not. > > You could issue a "SAVEPOINT name". If at the end you don't want your > changes to apply, you can issue a "ROLLBACK to name"
Actually you can't use SAVEPOINT nor ROLLBACK TO within a function. In PL/pgSQL you can use EXCEPTION blocks (if you don't like the changes, just do a RAISE EXCEPTION, and the exception block is run). -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
