Re: Problem with DEBUG messages - Mailing list pgadmin-support

From Michael Shapiro
Subject Re: Problem with DEBUG messages
Date
Msg-id CAGCvxebmi2gu2d7dvgxRfx3SmiV8WNc+U0943bSPddjURsjfFg@mail.gmail.com
Whole thread Raw
In response to Re: Problem with DEBUG messages  (Dave Page <dpage@pgadmin.org>)
Responses Re: Problem with DEBUG messages
List pgadmin-support
Yes and no.

If I run the script that creates the function, does the set client_min_messages, then runs the function,
I get the DEBUG.

But then if I just runt he function (in a new query window). I do not get the DEBUG messages.

However, if I add

    SET client_min_messages to 'DEBUG';

in the query window before I run the function, I see the messages.

So

  select test_debug(1)

doesn't work, but


   SET client_min_messages to 'DEBUG';
   select test_debug(1)

does work,

On Tue, Apr 9, 2013 at 10:53 AM, Dave Page <dpage@pgadmin.org> wrote:
On Tue, Apr 9, 2013 at 4:47 PM, Michael Shapiro <mshapiro51@gmail.com> wrote:
> 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 ...
>

Does my test script work for you?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Problem with DEBUG messages
Next
From: Veenu Kumar Mani
Date:
Subject: pgadmin II