Search Postgresql Archives

Re: How disable context view in RAISE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Aug 19, 2005 at 10:10:41AM +0200, dknoto@xxxxxxxxxxx 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux