SEO

#1 (**permalink**) 04-09-2008, 02:33 PM

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?

#2 (**permalink**) 04-09-2008, 02:33 PM

"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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

#3 (**permalink**) 04-09-2008, 02:33 PM

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.

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
>

#4 (**permalink**) 04-09-2008, 02:42 PM

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. +

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to disable displaying of a NOTICE context?