Re: Problem with DEBUG messages

I have a very similar function and client_min_message set exactly the same,<br />When I run the procedure in the query
tool,I do not see any DEBUG message.<br />If I run it in PSQL console, the DEBUG message appear.<br /><br />There must
besomething in PgAdmin that is doing this ...<br /><br /><div class="gmail_quote">On Tue, Apr 9, 2013 at 10:01 AM, Dave
Page<span dir="ltr"><<a href="mailto:dpage@pgadmin.org" target="_blank">dpage@pgadmin.org</a>></span> wrote:<br
/><blockquoteclass="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Hi<br /><div
class="im"><br/> On Mon, Apr 8, 2013 at 5:58 PM, Michael Shapiro <<a
href="mailto:mshapiro51@gmail.com">mshapiro51@gmail.com</a>>wrote:<br /> > Hi Dave,<br /> ><br /> > I
reporteda problem I am having with PgAdmin and DEBUG messages (April<br /> > 2nd). There has been no repsonse. I am
prettysure it is a PgAdmin issue, as<br /> > other tools show the DEBUG messages but they do not show in PgAdmin.<br
/><br/></div>It works for me (form the history pane):<br /><br /> -- Executing query:<br /> CREATE OR REPLACE FUNCTION
test_debug(valinteger)<br />   RETURNS integer AS<br /> $$<br /> DECLARE<br /> BEGIN<br />     IF val > 0 THEN<br />
       RAISE DEBUG 'Value: %', val;<br />         RETURN val;<br />     ELSE<br />         RETURN 0;<br />     END
IF;<br/> END;<br /> $$<br /> LANGUAGE 'plpgsql' IMMUTABLE;<br /><br /> SET client_min_messages to 'DEBUG';<br /><br />
SELECTtest_debug(1)<br /><br /> DEBUG:  Value: 1<br /> Total query runtime: 13 ms.<br /><br /> 1 row retrieved.<br
/><br/> --<br /> Dave Page<br /> Blog: <a href="http://pgsnake.blogspot.com"
target="_blank">http://pgsnake.blogspot.com</a><br/> Twitter: @pgsnake<br /><br /> EnterpriseDB UK: <a
href="http://www.enterprisedb.com"target="_blank">http://www.enterprisedb.com</a><br /> The Enterprise PostgreSQL
Company<br/></blockquote></div><br />