what's the message: CONTEXT: PL/pgSQL function "proc_sub_b" line 7 at assignment - Mailing list pgsql-general

From Gary Fu
Subject what's the message: CONTEXT: PL/pgSQL function "proc_sub_b" line 7 at assignment
Date
Msg-id ifgc5q$1u1i$1@news.hub.org
Whole thread Raw
Responses Re: what's the message: CONTEXT: PL/pgSQL function "proc_sub_b" line 7 at assignment  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Hi,

Why do I get the message in Subject when I do 'select proc_sub_b()'
under psql ?  If I comment out the RAISE statement in proc_sub_a then I
don't see the message.

Thanks,
Gary

int_admin.modaps_int> select proc_sub_b();
INFO:  id=11
CONTEXT:  PL/pgSQL function "proc_sub_b" line 7 at assignment
  proc_sub_b
------------
           0
(1 row)

------------------------------------------------------------
CREATE OR REPLACE FUNCTION proc_sub_a(
   v_id  int
) RETURNS INTEGER AS $$
DECLARE
BEGIN

   RAISE INFO 'id=%', v_id;

   return 1;

end;
$$ LANGUAGE plpgsql;


CREATE OR REPLACE FUNCTION proc_sub_b(
) RETURNS INTEGER AS $$
DECLARE
   v_ret int;
BEGIN

   v_ret := proc_sub_a(11);

   return 0;

end;
$$ LANGUAGE plpgsql;

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: Re: B-tree + sorting + unique constraint
Next
From: Adrian Klaver
Date:
Subject: Re: what's the message: CONTEXT: PL/pgSQL function "proc_sub_b" line 7 at assignment