How disable context view in RAISE

Поиск
Список
Период
Сортировка
Искать

How disable context view in RAISE

От:
dknoto@wiml.waw.pl
Дата:
Hi All,

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 ?

Best regards
-- 
Dariusz Knociński

Re: How disable context view in RAISE

От:
Michael Fuhr <mike@fuhr.org>
Дата:
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
FAQ