Re: [NOVICE] A very simple question about rollback/commit - 07-16-2012 , 02:27 PM
On Mon, 2012-07-09 at 11:09 -0400, Della-Croce, Gregory wrote:
In particular, look at:
That last one will tell you about the BEGIN/EXCEPTION block, which is I
think what you want. Internally, that uses savepoints so you don't have
to. (In fact, it might be impossible to use savepoints in PL/pgSQL, and
you might have to use the BEGIN/EXCEPTION block).
If PL/pgSQL is not already installed, you may need to create it in your
If you use later versions of postgresql, then PL/pgSQL is installed by
default, and you can use the a "DO" block rather than creating a
I know that's a lot of information all at once, but I hope it's helpful.
Sent via pgsql-novice mailing list (pgsql-novice (AT) postgresql (DOT) org)
To make changes to your subscription: