Problems with $libdir on PostgreSQL
Posted
by Joe Germuska
on Stack Overflow
See other posts from Stack Overflow
or by Joe Germuska
Published on 2009-08-28T19:51:27Z
Indexed on
2010/06/11
9:02 UTC
Read the original article
Hit count: 452
In short, my question is "why doesn't $libdir work on my PSQL installation."
CREATE FUNCTION st_box2d_in(cstring) RETURNS box2d
AS '$libdir/liblwgeom', 'BOX2DFLOAT4_in'
LANGUAGE c IMMUTABLE STRICT;
yields an error
could not access file "$libdir/liblwgeom": No such file or directory
while
CREATE FUNCTION st_box2d_in(cstring) RETURNS box2d
AS '/usr/local/pgsql/lib/liblwgeom', 'BOX2DFLOAT4_in'
LANGUAGE c IMMUTABLE STRICT;
works correctly.
The output of
% pg_config --pkglibdir
/usr/local/pgsql/lib
appears to be correct.
© Stack Overflow or respective owner
