RAISE NOTICE ... and CONTEXT field of the error report.

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: RAISE NOTICE ... and CONTEXT field of the error report.
Date: 2013-01-22 13:59:44
Message-ID: CAAfz9KMFEX6FHTxBckCPags-szijJVBCGOMfeNEGGmN1HEACYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Schablewski 2013-01-22 14:03:26 Re: RAISE NOTICE ... and CONTEXT field of the error report.
Previous Message Marc Schablewski 2013-01-22 13:57:26 Re: Update rule on a view - what am I doing wrong