Re: Manual fixing of plpgsql_call_handler binary location

On Sat, Jun 28, 2003 at 01:25:12AM -0400, Tom Lane wrote:
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> >>> Will I destroy things if I execute
> >>> update pg_proc set probin = '/usr/lib/pgsql/plpgsql.so' where proname = 'plpgsql_call_handler';
> >>
> >> Nope ... that's what I'd probably do.
>
> > Even better change it to '$libdir/plpgsql.so'.
>
> Good point. In fact the really preferred spelling (which you'd get from
> a fresh 'createlang' run) is just '$libdir/plpgsql'. Both the path and
> the shlib extension are better left to the backend to supply than to
> hardwire in. I'm possibly more aware of this than most folk, since I
> like to use HPUX which spells the shlib extension ".sl" ...

Awesome -- I've questioned to myself the wisdom of having this sort
of thing hardcoded, but it looks like it's already been solved.

Thanks, all...

--
Adam Haberlach | "When your product is stolen by thieves, you
adam(at)mediariffic(dot)com | have a police problem. When it is stolen by
http://mediariffic.com | millions of honest customers, you have a
| marketing problem." - George Gilder