Re: RAISE function misuse ? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: RAISE function misuse ?
Date
Msg-id 20060405025905.GB75532@winnie.fuhr.org
Whole thread Raw
In response to RAISE function misuse ?  (Patrick Refondini <patrick.refondini@pobox.com>)
Responses Re: RAISE function misuse ?
List pgsql-general
On Mon, Apr 03, 2006 at 05:44:18PM +0200, Patrick Refondini wrote:
> idns_target=# select test();
> INFO:  hello !
> CONTEXT:  SQL statement "SELECT  hello()"
> PL/pgSQL function "test" line 2 at perform

[...]

> 1. Is there anything wrong using RAISE this way.

Not in the sense of the code doing something it shouldn't.

> 2. Is there a way to get rid of the output:
> CONTEXT:  SQL statement "SELECT  hello()"
> PL/pgSQL function "test" line 2 at perform

test=> \set VERBOSITY terse
test=> select test();
INFO:  hello !
 test
------

(1 row)

--
Michael Fuhr

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE TABLE (with INHERITS) and ACCESS EXCLUSIVE locks
Next
From: Don Y
Date:
Subject: Re: User defined data type