$libdir under linux

Marios Vodas <mvodas@gmail.com> writes:

I want to create this function:
CREATE OR REPLACE FUNCTION myfunction(cstring)
RETURNS cstring AS
'$libdir/mylib','myfunction'
LANGUAGE 'C' IMMUTABLE STRICT;

In windows this is working fine and $libdir is substituted by the actual
path. In linux it is not substituted!

I rather doubt that, considering that it works fine for everybody else.

This is the error I get:
ERROR: could not access file "$libdir/mylib": No such file or directory

So is mylib.so actually there in the library directory? (Try
"pg_config --pkglibdir" to confirm which directory that is.)
If so, try ldd on it --- maybe the problem is with some library
it references, not mylib.so itself.

regards, tom lane