Re: BUG #2785: Exception Issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Patrick Hayes" <pkhayeskp(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2785: Exception Issue
Date: 2006-11-28 03:05:04
Message-ID: 27666.1164683104@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas H. 2006-11-28 03:11:18 Re: BUG #2781: database dump/restore problems
Previous Message Tom Lane 2006-11-28 03:01:06 Re: BUG #2782: Too Many open files in system