Re: Problem with DEBUG messages

On Tue, Apr 9, 2013 at 5:00 PM, Michael Shapiro <mshapiro51@gmail.com> wrote:
> 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,

After digging a bit further, this appears to be because pgAdmin's
connection management class runs this when it establishes a new
connection:

SET DateStyle=ISO;\nSET client_min_messages=notice;

in order to ensure that things are set up as expected. So, I'd suggest
just resetting client_min_messages if necessary when opening a query
window.

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

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