Re: CREATE EXTENSION to load the language into the database - Mailing list pgsql-general
From | Adrian Klaver |
---|---|
Subject | Re: CREATE EXTENSION to load the language into the database |
Date | |
Msg-id | f419e6b8-deeb-a901-9f08-303097bba2a7@aklaver.com Whole thread Raw |
In response to | CREATE EXTENSION to load the language into the database (Daulat Ram <Daulat.Ram@exponential.com>) |
Responses |
RE: CREATE EXTENSION to load the language into the database
|
List | pgsql-general |
On 5/3/19 8:56 AM, Daulat Ram wrote: > Hello team, > > We are getting below issue while creating a function in Potsgres 11.2 > > nagios=# create or replace function diskf (filesystem text, warn int, > err int) returns text as $BODY$ > > nagios$# use warnings; > > nagios$# use strict; > > nagios$# my $fs = $_[0]; > > nagios$# my $w = $_[1]; > > nagios$# my $e = $_[2]; > > nagios$# my $r = "WARNING"; > > nagios$# my $output = `df -kP $fs`; > > nagios$# $output =~ /.*\s+(\d+)%.*/; > > nagios$# $output = $1; > > nagios$# if ($output > $w) > > nagios$# { $r = "ERROR" if $output > $e;} > > nagios$# else { $r = "OK";} > > nagios$# return "$r $output"; > > nagios$# $BODY$ language plperlu; > > ERROR: language "plperlu" does not exist > > HINT: Use CREATE EXTENSION to load the language into the database. > > nagios=# SELECT * FROM pg_language; > > lanname | lanowner | lanispl | lanpltrusted | lanplcallfoid | laninline > | lanvalidator | lanacl > > ----------+----------+---------+--------------+---------------+-----------+--------------+-------- > > internal | 10 | f | f | 0 | 0 > | 2246 | > > c | 10 | f | f | 0 | 0 > | 2247 | > > sql | 10 | f | t | 0 | 0 > | 2248 | > > plpgsql | 10 | t | t | 13075 | 13076 > | 13077 | > > (4 rows) > > To solve this issue , I am getting the below warnings if creating > extensions. > > nagios=# CREATE EXTENSION plperl; > > ERROR: could not open extension control file > "/usr/local/share/postgresql/extension/plperl.control": No such file or > directory > > nagios=# CREATE LANGUAGE plperlu; > > ERROR: could not load library "/usr/local/lib/postgresql/plperl.so": > Error loading shared library libperl.so.5.20: No such file or directory > (needed by /usr/local/lib/postgresql/plperl.so) > > nagios=# CREATE LANGUAGE plperlu; > > ERROR: could not load library "/usr/local/lib/postgresql/plperl.so": > Error loading shared library libperl.so.5.20: No such file or directory > (needed by /usr/local/lib/postgresql/plperl.so) The plperl(u) extension has not been added to the Postgres installation. You need to do that. To help you with that we need to know: What OS(and version) are you using? How did you install Postgres? > > nagios=# > > Regards, > > Dault > -- Adrian Klaver adrian.klaver@aklaver.com
pgsql-general by date: