Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> writes:
> CREATE FUNCTION sbox_in(cstring) RETURNS sbox
> AS '/usr/local/pgsql802/lib/pg_sphere', 'spherebox_in'
> LANGUAGE c IMMUTABLE STRICT;
> Now if I can just figure out how to get this egg off my face...
You'd be a lot better off to define all your functions as relative to
$libdir, ie,
AS '$libdir/pg_sphere', 'spherebox_in'
(note the lack of any .so extension, too)
If pg_sphere is supplying a setup procedure that gets this wrong,
yell at them.
regards, tom lane