Re: Problem with DEBUG messages

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

> On Tue, Apr 9, 2013 at 4:47 PM, Michael Shapiro <mshapiro51(at)gmail(dot)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
>