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@pgadmin.org> wrote:
Hi
On Mon, Apr 8, 2013 at 5:58 PM, Michael Shapiro <
mshapiro51@gmail.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.
-- 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
