Re: [SQL] exception handling in postgres plpgsql

From: Joe <dev(at)freedomcircle(dot)net>
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-03 23:30:43
Message-ID: 1175643043.756.1.camel@pampa
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Hi,

On Tue, 2007-04-03 at 15:35 -0700, Karthikeyan Sundaram wrote:
> exception
> when NO_DATA_FOUND
> then
> return 100;
> end;
> $$
> language 'plpgsql';
>
> When I compile, I am getting an error message
> ERROR: unrecognized exception condition "no_data_found"
> CONTEXT: compile of PL/pgSQL function "audio_format_func" near line
> 15

The constant is no_data. See
http://www.postgresql.org/docs/8.2/static/errcodes-appendix.html

Joe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-04-04 00:24:12 Re: [SQL] exception handling in postgres plpgsql
Previous Message Karthikeyan Sundaram 2007-04-03 22:35:17 exception handling in postgres plpgsql

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2007-04-04 00:24:12 Re: [SQL] exception handling in postgres plpgsql
Previous Message Karthikeyan Sundaram 2007-04-03 22:35:17 exception handling in postgres plpgsql