User defined EXCEPTIONs

From: "vishal saberwal" <vishalsaberwal(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: User defined EXCEPTIONs
Date: 2006-03-07 18:34:39
Message-ID: 3e74dc250603071034q6ef2d160radb949abdb27922f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Using postgreSQL 8.1 on fedora.

Below is a function RowCount_Select(Table_Name) defined that raises
exception (test1) which i intend to catch in test1( ) and raise exception
(test2).
Do we have a way to catch such user defined exceptions? Can someone direct
me to the right resource pages?

create or replace function RowCount_Select(varchar) returns int as $$
DECLARE
res int;
BEGIN
select into res reltuples from pg_class where relkind='r' and
relname=$1;
if not found then
raise exception 'test1';
end if;
return res;
END;
$$ language plpgsql strict;

-- There is no relation by name ' test '
create or replace function test1() returns int as $$
DECLARE
res int;
BEGIN
select into res RowCount_Select('test');
return res;
EXCEPTION
when test1 then
raise exception 'test2';
END;
$$ language plpgsql strict;

ERROR: unrecognized exception condition "test1"
CONTEXT: compile of PL/pgSQL function "test1" near line 11

thanks,
vish

Responses

Browse pgsql-general by date

  From Date Subject
Next Message vishal saberwal 2006-03-07 18:48:43 Re: User defined EXCEPTIONs
Previous Message Emi Lu 2006-03-07 18:02:25 how to setup default privileges