> I am using the following sytex to handle exceptions in
> plpgsql (I am using postgres 8 rc1)
>
> ....some code ........
>
> EXCEPTION
> WHEN NO_DATA THEN
> RAISE NOTICE 'NO DATA';
> WHEN OTHERS THEN
> RAISE NOTICE 'An exception occurred';
> RETURN emp_rec;
>
> and i receive the following error
> ERROR: unrecognized exception condition "no_data"
>
> How can i rectify this error?
It seems you can’t trap every condition listed in errocodes-
appendix.html; in particular, you can’t trap SUCCESSFUL_COMPLETION, any
of the conditions listed in the WARNING category, or any of the
conditions listed in the NO DATA category. (At least through 8.0 rc1 -
I haven't checked in later versions).
-- Korry