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
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 |
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 |