Thread: Problems with "NOTICE"-messages

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

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

On Sep 17, 2:59 pm, dp...@postgresql.org (Dave Page) wrote:
> Hmm, works for me in SVN-Trunk (1.8 beta5 + a few minor unrelated tweaks):
> (...)
> Anyone else able to reproduce this?

I cannot reproduce it either.
Testing pgAdmin III 1.8.0  Beta 5 (Sep 10 2007, rev: 6631). Client Win
XP, host: Debian Etch / PG 8.2.4 and Debian Sarge / PG 8.1.8

All settings at default:
# log_error_verbosity = default
# client_min_messages = notice
#log_min_messages = notice

I get both notices, just as psql does.


Regards
Erwin