Re: Removing Context Messages

------=_Part_16630_22639601.1207659704863
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Tue, Apr 8, 2008 at 3:29 AM, Julius Tuskenis <julius@[EMAIL PROTECTED]
> wrote:

> Hello.
>
> What do you mean saying CONTEXT messages? Could you give an example what
> you get and what you want to get from your functions?
>
>
>
Sure. I have made a simple example to show this with 2 functions: f_outer
which loops through a recordset and calls f_inner for each record.

Context messages appear immediately after the f_inner function logs.
The output I'm getting when executing f_outer is:

NOTICE:  f_outer: 3
NOTICE:  f_inner: 3 = [HEVIA]
CONTEXT:  SQL statement "SELECT  f_inner( $1 )"
PL/pgSQL function "f_outer" line 9 at perform
NOTICE:  f_outer: 6
NOTICE:  f_inner: 6 = [GUIDARA]
CONTEXT:  SQL statement "SELECT  f_inner( $1 )"
PL/pgSQL function "f_outer" line 9 at perform
NOTICE:  f_outer: 7
NOTICE:  f_inner: 7 = [MASTROIANI]
CONTEXT:  SQL statement "SELECT  f_inner( $1 )"
PL/pgSQL function "f_outer" line 9 at perform  f_outer


I want to get rid of the CONTEXT messages:
  CONTEXT:  SQL statement "SELECT  f_inner( $1 )"
  PL/pgSQL function "f_outer" line 9 at perform  f_outer


--- Function declaration follows in case it helps ---
CREATE OR REPLACE FUNCTION f_inner(p_client numeric(10)) RETURNS void AS
$BODY$
DECLARE
  r_clients clientes%ROWTYPE;
BEGIN
  SELECT * INTO r_clients FROM clientes WHERE id_cliente = p_client;
  RAISE NOTICE 'f_inner: % = [%]', p_client, r_clients.apellido;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;

CREATE OR REPLACE FUNCTION f_outer() RETURNS void AS
$BODY$
DECLARE
  r_clients clientes%ROWTYPE;
BEGIN
  FOR r_clients IN SELECT * FROM CLIENTES
  LOOP
    RAISE NOTICE 'f_outer: %', r_clients.id_cliente;
    PERFORM f_inner(r_clients.id_cliente);
  END LOOP;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;

Regards,
Fernando.

------=_Part_16630_22639601.1207659704863
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br><div class="gmail_quote">On Tue, Apr 8, 2008 at 3:29 AM, Julius
Tuskenis &lt;<a href="mailto:julius@[EMAIL PROTECTED]
">julius@[EMAIL PROTECTED]
>&gt;
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello.<br>
<br>
What do you mean saying CONTEXT messages? 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 a recordset and calls f_inner
for each record.<br>&nbsp;<br>Context messages appear immediately after the
f_inner function logs.<br>
The output I&#39;m getting when executing f_outer
is:<br>&nbsp;<br>NOTICE:&nbsp; f_outer: 3<br>NOTICE:&nbsp; f_inner: 3 =
[HEVIA]<br>CONTEXT:&nbsp; SQL statement &quot;SELECT&nbsp; f_inner( $1
)&quot;<br>PL/pgSQL function &quot;f_outer&quot; line 9 at perform<br>
NOTICE:&nbsp; f_outer: 6<br>NOTICE:&nbsp; f_inner: 6 =
[GUIDARA]<br>CONTEXT:&nbsp; SQL statement &quot;SELECT&nbsp; f_inner( $1
)&quot;<br>PL/pgSQL function &quot;f_outer&quot; line 9 at
perform<br>NOTICE:&nbsp; f_outer: 7<br>NOTICE:&nbsp; f_inner: 7 =
[MASTROIANI]<br>
CONTEXT:&nbsp; SQL statement &quot;SELECT&nbsp; f_inner( $1
)&quot;<br>PL/pgSQL function &quot;f_outer&quot; line 9 at perform&nbsp;
f_outer<br> <br><br>I want to get rid of the CONTEXT messages:<br>&nbsp;
CONTEXT:&nbsp; SQL statement &quot;SELECT&nbsp; f_inner( $1 )&quot;<br>
&nbsp; PL/pgSQL function &quot;f_outer&quot; line 9 at perform&nbsp;
f_outer<br> <br>&nbsp;<br>--- Function declaration follows in case it
helps --- <br>CREATE OR REPLACE FUNCTION f_inner(p_client numeric(10))
RETURNS void AS $BODY$ <br>
DECLARE<br>&nbsp; r_clients clientes%ROWTYPE;<br>BEGIN<br>&nbsp; SELECT *
INTO r_clients FROM clientes WHERE id_cliente = p_client;<br>&nbsp; RAISE
NOTICE &#39;f_inner: % = [%]&#39;, p_client, r_clients.apellido; <br>END;
<br>$BODY$ <br>
LANGUAGE &#39;plpgsql&#39; VOLATILE;<br>&nbsp;<br>CREATE OR REPLACE
FUNCTION f_outer() RETURNS void AS <br>$BODY$ <br>DECLARE<br>&nbsp;
r_clients clientes%ROWTYPE;<br>BEGIN<br>&nbsp; FOR r_clients IN SELECT *
FROM CLIENTES<br>&nbsp; LOOP<br>
&nbsp;&nbsp;&nbsp; RAISE NOTICE &#39;f_outer: %&#39;,
r_clients.id_cliente;<br>&nbsp;&nbsp;&nbsp; PERFORM
f_inner(r_clients.id_cliente);<br>&nbsp; END
LOOP;<br>END;<br>$BODY$<br>LANGUAGE &#39;plpgsql&#39;
VOLATILE;<br><br>Regards,<br>Fernando.<br>

------=_Part_16630_22639601.1207659704863--