Re: How disable context view in RAISE

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