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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi folks:

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

This is what I know:

- pg has been configured --with perl
- the libdir is /usr/lib
- there are and 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;

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'
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!


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-2017 The PostgreSQL Global Development Group