| 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: | Whole Thread | Raw Message | 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
| 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 |