postgres a relocation error

[Karel Zak - Zakkr]

On Mon, 21 Feb 2000, Michal Fric wrote:

> postgres=> CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
>            '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';
> CREATE
> postgres=> CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
>            HANDLER plpgsql_call_handler
>            LANCOMPILER 'PL/pgSQL';
> CREATE

Instalace PL/pgSQL neni standardne?

> postgres=>  CREATE FUNCTION add_one (int4) RETURNS int4 AS '
>             BEGIN
>               RETURN $1 + 1;
>             END;
>             ' LANGUAGE 'plpgsql';
> CREATE
> postgres=> select add_one(*);
> ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.so failed: ld.so.1:
> /usr/local/pgsql/bin/postmaster: fatal: relocation error: file
> /usr/local/pgsql/lib/plpgsql.so: symbol CurrentMemoryContext: referenced symbol
> not found

No asi se neporari slinkovat - dlopen() - tu knihovnu s PG. To 
CurrentMemoryContext asi na nic "nenavazuje". Je to kompilovane
oboje ze stejneho stromu a pod stejnym OS ..atd?

						Karel