| -- test warnings and errors from plperl |
| |
| create or replace function perl_elog(text) returns void language plperl as $$ |
| |
| my $msg = shift; |
| elog(NOTICE,$msg); |
| |
| $$; |
| |
| select perl_elog('explicit elog'); |
| |
| create or replace function perl_warn(text) returns void language plperl as $$ |
| |
| my $msg = shift; |
| warn($msg); |
| |
| $$; |
| |
| select perl_warn('implicit elog via warn'); |
| |
| -- test strict mode on/off |
| |
| SET plperl.use_strict = true; |
| |
| create or replace function uses_global() returns text language plperl as $$ |
| |
| $global = 1; |
| $other_global = 2; |
| return 'uses_global worked'; |
| |
| $$; |
| |
| select uses_global(); |
| |
| SET plperl.use_strict = false; |
| |
| create or replace function uses_global() returns text language plperl as $$ |
| |
| $global = 1; |
| $other_global=2; |
| return 'uses_global worked'; |
| |
| $$; |
| |
| select uses_global(); |