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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | venkatrao.b | 2010-03-06 10:11:40 | How to find details of arguments in all functions in postgre - One solution |
Previous Message | Tim Landscheidt | 2010-03-06 01:20:06 | Re: WHERE AND JOIN STATEMENTS |