RE: [GENERAL] plpgsql problem: relocation error

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