I have a very similar function and client_min_message set exactly the same, When I run the procedure in the query tool, I do not see any DEBUG message. If I run it in PSQL console, the DEBUG message appear.
There must be something in PgAdmin that is doing this ... On Tue, Apr 9, 2013 at 10:01 AM, Dave Page <dp...@pgadmin.org> wrote: > Hi > > On Mon, Apr 8, 2013 at 5:58 PM, Michael Shapiro <mshapir...@gmail.com> > wrote: > > Hi Dave, > > > > I reported a problem I am having with PgAdmin and DEBUG messages (April > > 2nd). There has been no repsonse. I am pretty sure it is a PgAdmin > issue, as > > other tools show the DEBUG messages but they do not show in PgAdmin. > > It works for me (form the history pane): > > -- Executing query: > CREATE OR REPLACE FUNCTION test_debug(val integer) > RETURNS integer AS > $$ > DECLARE > BEGIN > IF val > 0 THEN > RAISE DEBUG 'Value: %', val; > RETURN val; > ELSE > RETURN 0; > END IF; > END; > $$ > LANGUAGE 'plpgsql' IMMUTABLE; > > SET client_min_messages to 'DEBUG'; > > SELECT test_debug(1) > > DEBUG: Value: 1 > Total query runtime: 13 ms. > > 1 row retrieved. > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company >
