plpgsql problem: relocation error
От | Andrew Perrin - Demography |
---|---|
Тема | plpgsql problem: relocation error |
Дата | |
Msg-id | Pine.SUN.4.10.9911022015460.26283-100000@davis.DEMOG.berkeley.edu обсуждение исходный текст |
Список | pgsql-general |
Greetings. Using pg6.5.1 on Solaris 2.6, I'm trying to create a very simple function using plpgsql. Here's the code I've executed: /* CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS '/opt/pgsql/lib/plpgsql.so' LANGUAGE 'C'; CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'; */ CREATE FUNCTION bool(int2) returns bool as 'begin if $1 = 1 or $1 = -1 then RETURN t; else RETURN f; end if; end;' language 'plpgsql'; All of this loads fine. However, when I test the function, this is what happens: demogdata=> select bool(-1); ERROR: Load of file /opt/pgsql/lib/plpgsql.so failed: ld.so.1: /opt/pgsql/bin/postmaster: fatal: relocation error: file /opt/pgsql/lib/plpgsql.so: symbol CurrentMemoryContext: referenced symbol not found Any ideas will be much appreciated. --------------------------------------------------------------------- Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support Department of Demography - University of California at Berkeley 2232 Piedmont Avenue #2120 - Berkeley, California, 94720-2120 USA http://demog.berkeley.edu/~aperrin --------------------------SEIU1199
В списке pgsql-general по дате отправления: