Re: Problem with DEBUG messages

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 <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> On Mon, Apr 8, 2013 at 5:58 PM, Michael Shapiro <mshapiro51(at)gmail(dot)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
>