Re: How disable context view in RAISE - Mailing list pgsql-general

From Michael Fuhr
Subject Re: How disable context view in RAISE
Date
Msg-id 20050819135551.GA83819@winnie.fuhr.org
Whole thread Raw
In response to How disable context view in RAISE  (dknoto@wiml.waw.pl)
List pgsql-general
On Fri, Aug 19, 2005 at 10:10:41AM +0200, dknoto@wiml.waw.pl wrote:
> I have many noise messages with context view in plpgsl.
> I have to trace my procedure but I can't disable context view after
> "raise notice". How disable this feature ?

What do you mean by "context view"?  Are you referring to CONTEXT
messages like the following?

test=> SELECT foo();
NOTICE:  test notice
CONTEXT:  PL/pgSQL function "foo" line 2 at return
  foo
-------
 12345
(1 row)

If so, and if you're using psql, then you can set psql's VERBOSITY
variable to silence the CONTEXT messages:

test=> \set VERBOSITY terse
test=> SELECT foo();
NOTICE:  test notice
  foo
-------
 12345
(1 row)

If that's not what you're looking for then please provide more
information.

--
Michael Fuhr

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: threads and transaction ...sample code and stored procedure
Next
From: Tom Lane
Date:
Subject: Re: Stored functions