From: | Renê Salomão <rene(at)ibiz(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
Subject: | Installing PlPerl |
Date: | 2003-05-21 16:26:35 |
Message-ID: | 20030521132635.016cab1a.rene@ibiz.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
Hi list...
I am trying to install PLPERL in Postgresql in order to use
regular expression to eliminate any undesired character in any given
name to be inserted in the database... I believe that using plperl is
less time consuming than doing the same approach using plpgsql
(correct if I am wrong please)...
However I was faced with the following error:
$pgsql > createlang plperl template1
ERROR: Load of file /usr/local/postgresql-7.3.2/lib/plperl.so failed:
libperl.so: cannot open shared object file: No such file or directory
createlang: language installation failed
Could somebody gimme a hand!!!!
My machine:
Athlon 1.3Mhz 512Mb
Mdk 9
Postgresql 7.3.2
pg_config --configure
'--prefix=/usr/local/postgresql-7.3.2'
'--with-perl'
'--with-tcl'
'--with-pgport=5433'
'CC=gcc'
'CFLAGS=-O2 -fpic -march=athlon-mcpu=athlon'
Following is my timing consume function (remember I'Perl's newbie)
to generate a name capitalized without any punctuation/number... Any
suggestion/comment to improve function, it will be welcome...
CREATE OR REPLACE FUNCTION XP_FORMATA_NOME (VARCHAR) RETURNS
VARCHAR AS '
my $string = @_;
$string =~ tr/[a-z][0-9]\.\$%\'"@#*!?()/[A-Z] /d;
RETURN $string;
'
LANGUAGE 'plperl';
Tks...
From | Date | Subject | |
---|---|---|---|
Next Message | nolan | 2003-05-21 16:54:18 | Re: DBI connection to multiple database |
Previous Message | ahoward | 2003-05-21 16:22:01 | Re: [GENERAL] pam-linux, /etc/shadow : HOW-TO |
From | Date | Subject | |
---|---|---|---|
Next Message | Nicholas Allen | 2003-05-21 16:57:53 | How to send an email when data is inserted into a table |
Previous Message | Chris Cameron | 2003-05-21 16:12:02 | Re: Unaccounted for disk use |