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