Christopher Kings-Lynne <chriskl@familyhealth.com.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" ...
regards, tom lane