Problems with "NOTICE"-messages
От | Bintsarovsky Dima home |
---|---|
Тема | Problems with "NOTICE"-messages |
Дата | |
Msg-id | 347441190011370@webmail9.yandex.ru обсуждение исходный текст |
Ответы |
Re: Problems with "NOTICE"-messages
|
Список | 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 executeSELECT 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
В списке pgadmin-support по дате отправления: