Re: RAISE function misuse ?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Patrick Refondini <patrick(dot)refondini(at)pobox(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: RAISE function misuse ?
Date: 2006-04-05 02:59:05
Message-ID: 20060405025905.GB75532@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Don Y 2006-04-05 06:18:18 Re: User defined data type
Previous Message Tom Lane 2006-04-05 02:53:39 Re: CREATE TABLE (with INHERITS) and ACCESS EXCLUSIVE locks