| 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: | Whole Thread | Raw Message | 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 |