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