Re: Manual fixing of plpgsql_call_handler binary location

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