Re: [SQL] exception handling in postgres plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] exception handling in postgres plpgsql
Date: 2007-04-04 00:24:12
Message-ID: 14030.1175646252@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com> writes:
> When I compile, I am getting an error message
> ERROR: unrecognized exception condition "no_data_found"CONTEXT: compile o=
> f PL/pgSQL function "audio_format_func" near line 15
> =20
> How will I handle exceptions in postgres?

Reading between the lines I gather that you are reading 8.2
documentation and trying to apply the info to some previous version that
doesn't have SELECT INTO STRICT (which you failed to use anyway...)

You probably want to test the magic FOUND variable instead --- see the
plpgsql docs.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Igor Neyman 2007-04-04 13:17:50 Re: exception handling in postgres plpgsql
Previous Message Joe 2007-04-03 23:30:43 Re: [SQL] exception handling in postgres plpgsql

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2007-04-04 05:01:16 Re: plpgsql function question
Previous Message Joe 2007-04-03 23:30:43 Re: [SQL] exception handling in postgres plpgsql