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
