Christopher Kings-Lynne <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])