RE: [GENERAL] plpgsql problem: relocation error - Mailing list pgsql-general
From | Andrew Perrin - Demography |
---|---|
Subject | RE: [GENERAL] plpgsql problem: relocation error |
Date | |
Msg-id | Pine.SUN.4.10.9911030923280.9029-100000@davis.DEMOG.berkeley.edu Whole thread Raw |
List | pgsql-general |
Thanks, but unfortunately, that's not it: postgres@davis:~>ls -l /opt/pgsql/lib/plpgsql.so -rwxr-xr-x 1 postgres 122312 Jul 15 14:27 /opt/pgsql/lib/plpgsql.so postgres@davis:~>psql demogdata Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL [PostgreSQL 6.5.0 on sparc-sun-solaris2.6, compiled by /usr/local/bin/gcc ] type \? for help on slash commands type \q to quit type \g or terminate with semicolon to execute query You are currently connected to the database: demogdata 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 other ideas? --------------------------------------------------------------------- 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 On Wed, 3 Nov 1999, Andrzej Mazurkiewicz wrote: > Check whether you have that library in the specified directory, whether > postgres account has access to it. You may have xxx.so.1 instead of xxx.so ( > symbolic link is enough). > Andrzej > > > -----Original Message----- > > From: Andrew Perrin - Demography [SMTP:aperrin@demog.berkeley.edu] > > Sent: 2 listopada 1999 21:18 > > To: pgsql-general@postgreSQL.org > > Subject: [GENERAL] plpgsql problem: relocation error > > > > 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 by date: