Postgres Pro
Downloads
Home   >   mailing lists

RAISE NOTICE ... and CONTEXT field of the error report. - Mailing list pgsql-general

From Dmitriy Igrishin
Subject RAISE NOTICE ... and CONTEXT field of the error report.
Date
Msg-id CAAfz9KMFEX6FHTxBckCPags-szijJVBCGOMfeNEGGmN1HEACYg@mail.gmail.com
Whole thread Raw
Responses Re: RAISE NOTICE ... and CONTEXT field of the error report.  (Marc Schablewski <ms@clickware.de>)
List pgsql-general
Tree view
Hey all,

Is there way to turn off printing of CONTEXT field of the error report
in the following case:

create or replace function foo() returns void language plpgsql as $$
begin
  raise notice 'notice from foo()';
end;
$$;
create or replace function bar() returns void language plpgsql as $$
begin
  perform foo();
end;
$$;

wog=# select foo();
NOTICE:  notice from foo()
 foo 
-----
 
(1 row)

wog=# select bar();
NOTICE:  notice from foo()
CONTEXT:  SQL statement "SELECT foo()"
PL/pgSQL function bar() line 3 at PERFORM
 bar 
-----
 
(1 row)

If it does not possible, I would like to have this feature. From the POV
of the PL/pgSQL user I think it should be customizable mode of PL/pgSQL.

--
// Dmitriy.

pgsql-general by date:

Previous
From: Marc Schablewski
Date:
Subject: Re: Update rule on a view - what am I doing wrong
Next
From: Marc Schablewski
Date:
Subject: Re: RAISE NOTICE ... and CONTEXT field of the error report.