Re: parallel pg installation and functions gotcha

Joe Slag <joe(dot)slag(at)walkerart(dot)org> writes:
> CREATE FUNCTION plpgsql_call_handler () RETURNS opaque
> AS '/usr/local/lib/plpgsql.so', 'plpgsql_call_handler'
> LANGUAGE "C";

> My solution: switch the lines in the output of pg_dumpall to point to the
> current plpgsql.so, and restore normally. Everything works now.

The preferred definition nowadays uses a version-independent
reference to the installation's library directory:

CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler
AS '$libdir/plpgsql', 'plpgsql_call_handler'
LANGUAGE c;

Unfortunately we were not bright enough to make it like that from day
one, so old dump files are a hazard :-(

regards, tom lane