Installing PlPerl
| От | Renê Salomão | 
|---|---|
| Тема | Installing PlPerl | 
| Дата | |
| Msg-id | 20030521132635.016cab1a.rene@ibiz.com.br обсуждение исходный текст | 
| Ответы | Re: Installing PlPerl Re: [GENERAL] Installing PlPerl | 
| Список | 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...
		
	В списке pgsql-novice по дате отправления: