Re: exception handling in plpgsql

<blockquote type="CITE"><pre>
<font color="#000000">I am using the following sytex to handle exceptions in</font>
<font color="#000000">plpgsql (I am using postgres 8 rc1)</font>

<font color="#000000">....some code ........</font>

<font color="#000000">EXCEPTION</font>
<font color="#000000">    WHEN NO_DATA THEN      </font>
<font color="#000000">       RAISE NOTICE 'NO DATA';</font>
<font color="#000000">    WHEN OTHERS THEN</font>
<font color="#000000">        RAISE NOTICE 'An exception occurred';</font>
<font color="#000000">        RETURN emp_rec;</font>

<font color="#000000">and i receive the following error </font>
<font color="#000000">ERROR:  unrecognized exception condition "no_data"</font>

<font color="#000000">How can i rectify this error?</font>
</pre></blockquote><br /> It seems you can’t trap every condition listed in errocodes-appendix.html; in particular, you
can’ttrap <tt>SUCCESSFUL_COMPLETION</tt>, any of the conditions listed in the <tt>WARNING</tt> category, or any of the
conditionslisted in the <tt>NO DATA</tt> category.  (At least through 8.0 rc1 - I haven't checked in later
versions).<br/><br />         -- Korry