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: 455

Filed under:
|
|

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

Related posts about postgresql

Related posts about postgis