Problems with "NOTICE"-messages

From: Bintsarovsky Dima home <bintsarovsky(at)yandex(dot)ru>
To: pgadmin-support(at)postgresql(dot)org
Subject: Problems with "NOTICE"-messages
Date: 2007-09-17 06:42:50
Message-ID: 347441190011370@webmail9.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I have two functions:

CREATE OR REPLACE FUNCTION tests.func1()
RETURNS integer AS
$BODY$
DECLARE
BEGIN
RAISE NOTICE 'notice';
PERFORM tests.func2();
RETURN 1;
END;$BODY$
LANGUAGE 'plpgsql' VOLATILE;

CREATE OR REPLACE FUNCTION tests.func2()
RETURNS integer AS
$BODY$
DECLARE
BEGIN
RAISE NOTICE 'SUBnotice';
RETURN 1;
END;$BODY$
LANGUAGE 'plpgsql' VOLATILE;

If I call SELECT tests.func1(), then in messages-dialog I can see a notice from tests.func1() only, but not from tests.func2() (as I know, PgAdmin has to show this notice with "CONTEXT....."). What's the problem? By the way, if I execute SELECT tests.func1() in psql I can see both notices.

I have this problem both in 1.6.3 and 1.8 versions of PgAdmin
OS: Windows XP
log_error_verbosity = DEFAULT
client_min_messages = NOTICE
log_min_messages = NOTICE

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Harald Armin Massa 2007-09-17 10:07:13 Positionioning of Dialog Windows / pgadmin 1.8 beta 5
Previous Message Jason L. Buberel 2007-09-17 01:01:22 Feature suggestion