Skip site navigation (1) Skip section navigation (2)

problems loading languages

From: Mija Lee <mija(at)scharp(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: problems loading languages
Date: 2007-09-11 15:55:12
Message-ID: 200709111555.l8BFtBka021076@brood2.pc.scharp.org (view raw or flat)
Thread:
Lists: pgsql-novice
Hi folks:

I am doing a fresh install of 8.2.4 and have been having problems with language 
support. 

This is what I know:

- pg has been configured --with perl
- the libdir is /usr/lib
- there are plpgsql.so and plperl.so in the libdir
- I get this:

postgres=# create language plperl;
ERROR:  could not access file "$libdir/plperl": No such file or directory

but other languages work fine:

postgres=# create language plpgsql;
CREATE LANGUAGE

My end goal is to be able to load the following function into template1:

CREATE FUNCTION plperl_call_handler() RETURNS language_handler
    AS '$libdir/plperl', 'plperl_call_handler'
    LANGUAGE c;
    
At least that's what the developers are telling me. This also gets the error 
about $libdir/plperl. Any ideas about what I'm doing wrong?

Thanks so much!
Mija


Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2007-09-11 18:40:19
Subject: Re: problems loading languages
Previous:From: johnfDate: 2007-09-11 13:50:07
Subject: Re: the copy command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group