Matthew Pounsett <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
