Bintsarovsky Dima home wrote: > 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.
Hmm, works for me in SVN-Trunk (1.8 beta5 + a few minor unrelated tweaks): NOTICE: notice NOTICE: SUBnotice CONTEXT: SQL statement "SELECT tests.func2()" PL/pgSQL function "func1" line 4 at perform Total query runtime: 15 ms. 1 rows retrieved. > 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 My server is 8.2.5 on XP: log_error_verbosity = default client_min_messages = notice log_min_messages = notice Which are all default settings. Anyone else able to reproduce this? Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
