Re: How to disable displaying of a NOTICE context?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: dmitry(at)koterov(dot)ru
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to disable displaying of a NOTICE context?
Date: 2007-03-20 18:11:21
Message-ID: 200703201811.l2KIBLn24568@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >
> > "Dmitry Koterov" <dmitry(at)koterov(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2007-03-20 18:41:50 Postgresql to Delphi
Previous Message Jonathan Vanasco 2007-03-20 18:03:11 sql indexing suggestions needed