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

Reply via email to