Re: COMMIT within function?

On Sun, 21 Nov 2004 20:10:03 -0700, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
>
> BEGIN
> DELETE FROM values WHERE value_id = r.value_id;
> EXCEPTION
> WHEN foreign_key_violation THEN
> NULL;
> END;

Ahh, exactly what I was looking for. :) The thing I didn't notice
was that, while exception causes rollback to "BEGIN", it does
not mean to the beginning of the function. In other words
I didn't nest BEGIN...END blocks and all I got from using
exceptions was that they did not show any errors. :)

Thank you! I am now enlightened. This works perfect, exactly
as I hoped it would. :)

Regards,
dawid