Thread: createlang plperl fails with 8.0 beta5

createlang plperl fails with 8.0 beta5

From
Joachim Zobel
Date:
Hi.

If I try createlang plperl I get:

postgres@asus:~$ /usr/local/pgsql/bin/createlang plperl shop
createlang: language installation failed: ERROR:  could not access file
"$libdir/plperl": No such file or directory

Checking my build dirs I find that no plperl.so has been build
(--with-perl was used in configure). Instead I find a libplperl.so in
the pgperl build directory.

Has plperl.so been renamed? Any hints on what is going wrong?

Thanks,
Joachim

--
"... ein Geschlecht erfinderischer Zwerge, die fuer alles gemietet werden
koennen."                            - Bertolt Brecht - Leben des Galilei


Re: createlang plperl fails with 8.0 beta5

From
Tom Lane
Date:
Joachim Zobel <jzobel@heute-morgen.de> writes:
> Checking my build dirs I find that no plperl.so has been build
> (--with-perl was used in configure). Instead I find a libplperl.so in
> the pgperl build directory.

That's how it's built, but it should be installed as plperl.so.  Are you
sure you are looking in the right $libdir?

            regards, tom lane

Re: createlang plperl fails with 8.0 beta5

From
Joachim Zobel
Date:
Am Mi, den 01.12.2004 schrieb Tom Lane um 21:22:
> Joachim Zobel <jzobel@heute-morgen.de> writes:
> > Checking my build dirs I find that no plperl.so has been build
> > (--with-perl was used in configure). Instead I find a libplperl.so in
> > the pgperl build directory.
>
> That's how it's built, but it should be installed as plperl.so.  Are you
> sure you are looking in the right $libdir?

I did not give any directory options during install, so

ls -l /usr/local/pgsql/lib/ | grep perl

should show it, right?

Thanks,
Joachim

--
"... ein Geschlecht erfinderischer Zwerge, die fuer alles gemietet werden
koennen."                            - Bertolt Brecht - Leben des Galilei


Re: createlang plperl fails with 8.0 beta5

From
Joachim Zobel
Date:
Am Mi, den 01.12.2004 schrieb Tom Lane um 22:00:

> Probably more like /usr/local/lib/postgresql ... did you look at the
> directory structure?  Or consult pg_config --pkglibdir ?

jo@asus:~$ /usr/local/pgsql/bin/pg_config --pkglibdir
/usr/local/pgsql/lib

and there is

jo@asus:~$ ls -l /usr/local/pgsql/lib/ | grep pl
-rwxr-xr-x  1 root staff  146322 2004-12-01 09:27 plpgsql.so

I fixed this by copying libplperl.so.0.0 to
/usr/local/pgsql/lib/plperl.so. Probably there is some glitch in the
Makefile or in ./configure.

Thx,
Joachim

--
"... ein Geschlecht erfinderischer Zwerge, die fuer alles gemietet werden
koennen."                            - Bertolt Brecht - Leben des Galilei


Re: createlang plperl fails with 8.0 beta5

From
Tom Lane
Date:
Joachim Zobel <jzobel@heute-morgen.de> writes:
> Am Mi, den 01.12.2004 schrieb Tom Lane um 21:22:
>> That's how it's built, but it should be installed as plperl.so.  Are you
>> sure you are looking in the right $libdir?

> I did not give any directory options during install, so
> ls -l /usr/local/pgsql/lib/ | grep perl
> should show it, right?

Probably more like /usr/local/lib/postgresql ... did you look at the
directory structure?  Or consult pg_config --pkglibdir ?

            regards, tom lane