plpgsql problem: relocation error

From: Andrew Perrin - Demography <aperrin(at)demog(dot)berkeley(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql problem: relocation error
Date: 1999-11-02 20:18:19
Message-ID: Pine.SUN.4.10.9911022015460.26283-100000@davis.DEMOG.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)demog(dot)berkeley(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 1999-11-02 21:09:49 Re: [GENERAL] error with user
Previous Message Mark Dalphin 1999-11-02 20:08:54 int8 index isn't used for query against number