Re: How disable context view in RAISE

On Fri, Aug 19, 2005 at 10:10:41AM +0200, dknoto(at)wiml(dot)waw(dot)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