Re: exception handling in plpgsql

PEBKAC.

It has told you what the problem is. Use a handler for an exception that 
actually exists. To see what these are, read 
http://developer.postgresql.org/docs/postgres/plpgsql-errors-and-messages.html

cheers

andrew

Sibtay Abbas wrote:

>hello
>
>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?
>
>
>    
>  
>