Re: Failure to load plpgsql.so

Matthew Pounsett <matt(at)conundrum(dot)com> writes:
> Im in the process of installing mediawiki, and ran into this error while it was setting up the database:

> Query:
> CREATE FUNCTION page_deleted() RETURNS TRIGGER LANGUAGE plpgsql AS $mw$ BEGIN DELETE FROM recentchanges WHERE rc_namespace = OLD.page_namespace AND rc_title = OLD.page_title; RETURN NULL; END; $mw$
> Function: DatabaseBase::sourceFile( /usr/local/www/mediawiki/maintenance/postgres/tables.sql )
> Error: 58P01 ERROR: could not load library "/usr/local/lib/postgresql/plpgsql.so": dlopen (/usr/local/lib/postgresql/plpgsql.so) failed: /usr/local/lib/postgresql/plpgsql.so: Undefined symbol "HeapTupleHeaderGetDatum"

This looks like you are using a 9.3.5 build of plpgsql.so with a server
that is 9.3.4 or older.

The most likely explanation of that is that you upgraded a 9.3.x
installation to 9.3.5 but neglected to actually restart the server.
"select version();" would help confirm what server version is running.

regards, tom lane