How to disable displaying of a NOTICE context?
Hello.
With debug purposes I use RAISE NOTICE ... inside my stored
functions/triggers. But there is a little problem: if I run this
function/trigger inside psql command-line client (e.g.), it shows not only a
notice text, but also a caller context (started with "CONTEXT" substring)
which looks quite huge and ugly.
Is there any way to disable CONTEXT displaying with still enabled NOTICEs
text?
"Dmitry Koterov" <dmitry@koterov.ru> writes:
Is there any way to disable CONTEXT displaying with still enabled NOTICEs
text?
You could do "\set VERBOSITY terse"
regards, tom lane
Thanks!
With RAISE NOTICE "terse" mode works great, CONTEXT is not shown.
But does "terse" also disable CONTEXT displaying on fatal errors inside a
stored function? If it does, it is not so useful as it could be, because I
don't think that fatal error context hiding is a good idea... No
documentation about it at all.
Show quoted text
On 3/13/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Dmitry Koterov" <dmitry@koterov.ru> writes:
Is there any way to disable CONTEXT displaying with still enabled
NOTICEs
text?
You could do "\set VERBOSITY terse"
regards, tom lane
Dmitry Koterov wrote:
Thanks!
With RAISE NOTICE "terse" mode works great, CONTEXT is not shown.
But does "terse" also disable CONTEXT displaying on fatal errors inside a
stored function? If it does, it is not so useful as it could be, because I
don't think that fatal error context hiding is a good idea... No
documentation about it at all.
I think you need to set it to 'terse', use RAISE, then reset it.
---------------------------------------------------------------------------
On 3/13/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Dmitry Koterov" <dmitry@koterov.ru> writes:
Is there any way to disable CONTEXT displaying with still enabled
NOTICEs
text?
You could do "\set VERBOSITY terse"
regards, tom lane
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +