On Tue, Apr 9, 2013 at 5:00 PM, Michael Shapiro <mshapir...@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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
