Robert Creager <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to