Re: SIGSEGV taken on 8.1 during dump/reload

Robert Creager <Robert_Creager@LogicalChaos.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