Re: Removing Context Messages

<br /><div class="gmail_quote">On Tue, Apr 8, 2008 at 3:29 AM, Julius Tuskenis <<a
href="mailto:julius@nsoft.lt">julius@nsoft.lt</a>>wrote:<br /><blockquote class="gmail_quote" style="border-left:
1pxsolid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Hello.<br /><br /> What do you mean saying
CONTEXTmessages? Could you give an example what you get and what you want to get from your functions?<br /><br /><br
/></blockquote></div><br/>Sure. I have made a simple example to show this with 2 functions: f_outer which loops through
arecordset and calls f_inner for each record.<br /> <br />Context messages appear immediately after the f_inner
functionlogs.<br /> The output I'm getting when executing f_outer is:<br /> <br />NOTICE:  f_outer: 3<br />NOTICE: 
f_inner:3 = [HEVIA]<br />CONTEXT:  SQL statement "SELECT  f_inner( $1 )"<br />PL/pgSQL function "f_outer" line 9 at
perform<br/> NOTICE:  f_outer: 6<br />NOTICE:  f_inner: 6 = [GUIDARA]<br />CONTEXT:  SQL statement "SELECT  f_inner( $1
)"<br/>PL/pgSQL function "f_outer" line 9 at perform<br />NOTICE:  f_outer: 7<br />NOTICE:  f_inner: 7 =
[MASTROIANI]<br/> CONTEXT:  SQL statement "SELECT  f_inner( $1 )"<br />PL/pgSQL function "f_outer" line 9 at perform 
f_outer<br/><br /><br />I want to get rid of the CONTEXT messages:<br />  CONTEXT:  SQL statement "SELECT  f_inner( $1
)"<br/>   PL/pgSQL function "f_outer" line 9 at perform  f_outer<br /><br /> <br />--- Function declaration follows in
caseit helps --- <br />CREATE OR REPLACE FUNCTION f_inner(p_client numeric(10)) RETURNS void AS $BODY$ <br />
DECLARE<br/>  r_clients clientes%ROWTYPE;<br />BEGIN<br />  SELECT * INTO r_clients FROM clientes WHERE id_cliente =
p_client;<br/>  RAISE NOTICE 'f_inner: % = [%]', p_client, r_clients.apellido; <br />END; <br />$BODY$ <br /> LANGUAGE
'plpgsql'VOLATILE;<br /> <br />CREATE OR REPLACE FUNCTION f_outer() RETURNS void AS <br />$BODY$ <br />DECLARE<br /> 
r_clientsclientes%ROWTYPE;<br />BEGIN<br />  FOR r_clients IN SELECT * FROM CLIENTES<br />  LOOP<br />     RAISE NOTICE
'f_outer:%', r_clients.id_cliente;<br />    PERFORM f_inner(r_clients.id_cliente);<br />  END LOOP;<br />END;<br
/>$BODY$<br/>LANGUAGE 'plpgsql' VOLATILE;<br /><br />Regards,<br />Fernando.<br />