Thread: what's the message: CONTEXT: PL/pgSQL function "proc_sub_b" line 7 at assignment

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;

On Wednesday 29 December 2010 2:19:40 pm Gary Fu wrote:
> 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
>

It is just giving the context for the raising of the INFO notice. You can change
that behavior by changing log_error_verbosity () See here for more detail:
http://www.postgresql.org/docs/9.0/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT



--
Adrian Klaver
adrian.klaver@gmail.com