Re: [BUGS] BUG #2785: Exception Issue

2006-11-28 Thread pat hayes
trick Hayes" <[EMAIL PROTECTED]> CC: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #2785: Exception Issue Date: Mon, 27 Nov 2006 22:05:04 -0500 "Patrick Hayes" <[EMAIL PROTECTED]> writes: > I get the following error. > postgres-# language plpgsql; > ER

Re: [BUGS] BUG #2785: Exception Issue

2006-11-27 Thread Tom Lane
"Patrick Hayes" <[EMAIL PROTECTED]> 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

[BUGS] BUG #2785: Exception Issue

2006-11-27 Thread Patrick Hayes
The following bug has been logged online: Bug reference: 2785 Logged by: Patrick Hayes Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows Professional Description:Exception Issue Details: I am defining Exception blocks. When I put so