From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Michael Shapiro <mshapiro51(at)gmail(dot)com> |
Cc: | Dinesh Kumar <dinesh(dot)kumar(at)enterprisedb(dot)com>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Problem with DEBUG messages |
Date: | 2013-04-09 15:01:31 |
Message-ID: | CA+OCxoxFvmdHJH2=JBW-wRwAS4EEFjR=Hromxf_vsazEs9B9AA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi
On Mon, Apr 8, 2013 at 5:58 PM, Michael Shapiro <mshapiro51(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Shapiro | 2013-04-09 15:47:41 | Re: Problem with DEBUG messages |
Previous Message | akande | 2013-04-09 12:31:48 | Password Needed |