iplike

The same error is thrown when executing install_iplike.sh - this wasn't happening before if I'm not mistaken, it seems I'm now unable to install IPLIKE.

It is in /usr/lib/postgresql/8.4/lib/iplike.la ... I don't know where it's looking for it that it can not find it. This is probably trivial issue with packaging but I don;t know how to work around it at this time ...

OK, it's looking for it in /usr/lib (god knows why), when I copy it there then it's looking for iplike.so also in /usr/lib so I copied that too. And then I get this error "ERROR: invalid macro name in dynamic library path: $PG_LIBDIR/$dlname" and that's where I'm stuck right now ...

Apologies for spamming the list but just as I think I can't move forward I discover the problem

I removed backward slashes from the CREATE string in install_iplike.sh script so it looks like this:

CREATE="CREATE OR REPLACE FUNCTION iplike(text,text) RETURNS bool AS '$PG_LIBDIR/$dlname' LANGUAGE 'c' WITH(isstrict);"

I assume they were escaping the dollar sign which is needed to interpret the variables and include their content in the string. This should probably solve it. So all the steps that were needed are:

cp /usr/lib/postgresql/8.4/lib/iplike.la /usr/lib
cp /usr/lib/postgresql/8.4/lib/iplike.so /usr/lib
change in install_iplike.sh: CREATE="CREATE OR REPLACE FUNCTION iplike(text,text) RETURNS bool AS '$PG_LIBDIR/$dlname' LANGUAGE 'c' WITH(isstrict);"

This bug should probably be solved by looking for the libraries in /usr/lib/postgresql/8.4/lib as opposed to /usr/lib and removing the backward slashes in install_iplike.sh

I hope this helps, kind regards

OK, this should be fixed now. Please let me know if you still see issues with the 2.0.2 package.