Re: Problem with DEBUG messages

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.

It works for me (form the history pane):

-- 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