RAISE function misuse ?

From: Patrick Refondini <patrick(dot)refondini(at)pobox(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: RAISE function misuse ?
Date: 2006-04-03 15:44:18
Message-ID: 443142D2.6060900@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I obtain the following output:

idns_target=# select test();
INFO: hello !
CONTEXT: SQL statement "SELECT hello()"
PL/pgSQL function "test" line 2 at perform

Using the two following functions:

CREATE OR REPLACE FUNCTION hello() RETURNS void AS $$
BEGIN
RAISE INFO 'hello !';
RETURN;
END;
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION test() RETURNS void AS $$
BEGIN
PERFORM hello();
RETURN;
END;
$$ LANGUAGE plpgsql;

I would like to know:
1. Is there anything wrong using RAISE this way.
2. Is there a way to get rid of the output:
CONTEXT: SQL statement "SELECT hello()"
PL/pgSQL function "test" line 2 at perform

I use PostgreSQL/psql 8.1.0

Thanks,

Patrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2006-04-03 16:15:23 Re: database design questions
Previous Message Richard Broersma Jr 2006-04-03 15:15:28 Re: database design questions