Issue with elog in plperl

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

Browse pgadmin-support by date

  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