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
> >
> >
> > ************
>