From: | Stephane FILLON <fillons(at)offratel(dot)nc> |
---|---|
To: | "'Andrew Perrin - Demography'" <aperrin(at)demog(dot)berkeley(dot)edu>, "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: [GENERAL] plpgsql problem: relocation error |
Date: | 1999-11-04 14:24:08 |
Message-ID: | 01BF2781.7C10E650.fillons@offratel.nc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Try to replace the following:
return t;
by return ''t'';
and return f; by return ''f'';
It's not a double quote but a quote quote :-)
-----Message d'origine-----
De: Andrew Perrin - Demography [SMTP:aperrin(at)demog(dot)berkeley(dot)edu]
Date: mercredi 3 novembre 1999 07:18
A: pgsql-general(at)postgreSQL(dot)org
Objet: [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(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
************
From | Date | Subject | |
---|---|---|---|
Next Message | Ïàíêîâ Ñâÿòîñëàâ | 1999-11-04 17:54:56 | Why lower() and upper() doesn't work ? |
Previous Message | Robert | 1999-11-04 11:45:00 | Re: [GENERAL] 6.5 connection time: too slow (?) |