Il Thursday 02 October 2008 17:10:23 Alvaro Herrera ha scritto: > Reg Me Please escribió: > > Il Thursday 02 October 2008 16:15:10 Alvaro Herrera ha scritto: > > > You can nest blocks arbitrarily, giving you the chance to selectively > > > rollback pieces of the function. It's only a bit more awkward. > > > > You mean I can issue a ROLLBACK command within a BEGIN...END; block to > > roll it back? > > No -- I mean you can use BEGIN/EXCEPTION/END blocks as you like, nesting > them or putting one after another. Complementing this with RAISE > EXCEPTION you can cause savepoints to roll back at will.
Now I understand. (Sorry, me dumb!) Looks quirky, but I trust it's working. I'll give that a try. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
