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

$libdir not working

From: Scott Geller <sgellergsu(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: $libdir not working
Date: 2010-03-06 01:30:55
Message-ID: c598163c1003051730p7541ed89w78a58b3c2dccc04@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello

Forgive the newb question...

I'm trying to run the code:
CREATE FUNCTION plr_call_handler()
RETURNS LANGUAGE_HANDLER
AS '$libdir/plr' LANGUAGE C;

and getting the error:
An error occurred when executing the SQL command:
CREATE FUNCTION plr_call_handler()
RETURNS LANGUAGE_HANDLER
AS '$libdir/plr' LANGUAGE C

ERROR: could not access file "$libdir/plr": No such file or directory
[SQL State=58P01]

Yet, I'm able to create the function with no problem when I run:
CREATE FUNCTION plr_call_handler()
RETURNS LANGUAGE_HANDLER
AS '/usr/lib/postgresql/plr' LANGUAGE C;

I found the location by running in bash:
pg_config --pkglibdir

I then tried to edit postgresql.conf by adding the line:
dynamic_library_path =  '/usr/lib/postgresql:$libdir'

I then reboot the OS and get the same error when trying to create the
function...

feels like postgres is not picking up the conf file, or at least the
line I added in the conf file.

appreciate any help!

Thanks

Scott

BTW - I'm using pclinuxos, and postgres 8.4

Responses

pgsql-novice by date

Next:From: venkatrao.bDate: 2010-03-06 10:11:40
Subject: How to find details of arguments in all functions in postgre - One solution
Previous:From: Tim LandscheidtDate: 2010-03-06 01:20:06
Subject: Re: WHERE AND JOIN STATEMENTS

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