From: | Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Issue with elog in plperl |
Date: | 2016-02-20 13:38:01 |
Message-ID: | 56C86C39.1080501@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello!
I think i found some bug with elog message exposure from plperl to pgadmin:
In version 1.22.0(Jan 8 2016, rev REL-1_22_0) i got some trouble with
incorrect behavior elog function in plperl
Here is example function :
CREATE OR REPLACE FUNCTION elog_test() RETURNS VOID AS $$
elog(INFO, "Vairiable doesn't exist");
elog(NOTICE, "Vairiable doesn't exist");
elog(WARNING, "Vairiable doesn't exist");
elog(ERROR, "Vairiable doesn't exist");
$$ LANGUAGE plperl;
select elog_test();
In version 1.20.0 (Dec 19 2014 rev: REL-1_20_0) i have in Message
Output pane:
INFO: Vairiable doesn't exist
CONTEXT: PL/Perl function "elog_test"
NOTICE: Vairiable doesn't exist
CONTEXT: PL/Perl function "elog_test"
WARNING: Vairiable doesn't exist
CONTEXT: PL/Perl function "elog_test"
ERROR: Vairiable doesn't exist at line 5.
CONTEXT: PL/Perl function "elog_test"
********** Error **********
ERROR: Vairiable doesn't exist at line 5.
SQL state: 38000
Context: PL/Perl function "elog_test"
But in version 1.22.0 in Message Output pane i have only :
********** Error **********
ERROR: Vairiable doesn't exist at line 5.
SQL state: 38000
Context: PL/Perl function "elog_test"
I.e i have only ERROR note and not other but in psql i have :
=> select elog_test();
INFO: Vairiable doesn't exist
CONTEXT: PL/Perl function "elog_test"
NOTICE: Vairiable doesn't exist
CONTEXT: PL/Perl function "elog_test"
WARNING: Vairiable doesn't exist
CONTEXT: PL/Perl function "elog_test"
ERROR: Vairiable doesn't exist at line 5.
CONTEXT: PL/Perl function "elog_test"
Thank you in advance!!!
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Lewis | 2016-02-22 18:41:10 | Adding users? |
Previous Message | Dave Page | 2016-02-19 11:42:10 | Re: Copy & paste key commands not working correctly |