Re: BUG #2785: Exception Issue

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Patrick Hayes" <pkhayeskp(at)hotmail(dot)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