Re: BUG #2785: Exception Issue - Mailing list pgsql-bugs

"Patrick Hayes" <pkhayeskp@hotmail.com> writes:
> I get the following error.

> postgres-# language plpgsql;
> ERROR:  unrecognized exception condition "no_data"
> CONTEXT:  compile of PL/pgSQL function "chip_pps_data_check" near line 101

Indeed, because no_data is not an error condition, so EXCEPTION can't
catch it.  Possibly you could do something with testing the FOUND
variable instead.

            regards, tom lane