Re: postgresql 7.0.3 -- but NO plperl ?

[will trillich <will@serensoft.com>]

On Tue, Feb 06, 2001 at 06:08:20PM -0800, Eric G . Miller wrote:
> On Tue, Feb 06, 2001 at 05:31:46PM -0600, will trillich wrote:
> > what do i need to get "plperl" active as a language from within
> > the new postgresql?
> 
> I don't know for sure, but take a look at /usr/lib/postgresql/lib.  Do
> you have libperl.so ?  If so, I guess the handler is there.  Now, you

% locate libperl
/usr/lib/perl5/5.005/i386-linux/CORE/libperl.a

% ls /usr/lib/postgresql/lib
global1.bki.source
global1.description
local1_template1.bki.source
local1_template1.description
pg_geqo.sample
pg_hba.conf.sample

i'm not so sure that libperl is what i'm looking for... ?

> can look at /usr/lib/postgresql/lib/makelang_pl.sql for an example of
> how to enable it.  I don't know why there isn't a plperl script, like
> the one for plpgsql.

from what oliver has told me, if i've got
	deb http://www.samfundet.no/~tfheen/debian potato main
in /etc/apt/sources.list, postgresql would come with perl at the ready.
not that it isn't true, but i seem to have a knack for hosing my postgresql
setup...

i found /usr/lib/postgresql/bin/enable_pgpl, which enables plpgsql
instead, and correctly reports that plpgsql is already active:

 lanname  | lanispl | lanpltrusted | lanplcallfoid | lancompiler 
----------+---------+--------------+---------------+-------------
 internal | f       | f            |             0 | n/a
 C        | f       | f            |             0 | /bin/cc
 sql      | f       | f            |             0 | postgres
 plpgsql  | t       | t            |         18560 | PL/pgSQL
(4 rows)

so where's plperl?

% dpkg -l postgre\*
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name           Version        Description
+++-==============-==============-============================================
un  postgres95     <none>         (no description available)
un  postgres95-dev <none>         (no description available)
ii  postgresql     7.0.3-0potato1 Object-relational SQL database, descended fr
ii  postgresql-cli 7.0.3-0potato1 Front-end programs for PostgreSQL
ii  postgresql-con 7.0.3-0potato1 Additional facilities for PostgreSQL
ii  postgresql-dev 7.0.3-0potato1 Header files for libpq (postgresql library)
ii  postgresql-doc 7.0.3-0potato1 Documentation for the PostgreSQL database.
ii  postgresql-pl  7.0.3-0potato1 A procedural language for PostgreSQL
in  postgresql-sli <none>         (no description available)

> Luck,

i need it!