I'm having the following problem with functions and triggers (and it
isn't an SQL problem.)
With PostgreSQL version 6.4.2 when I try to use a function or trigger
(either in C or plpgsql) I get the following message:
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 SPI_tuptable: referenced symbol
not found
The actual symbol not found depends on the function but it seems to me
that
the dynamic loader is having some problems. I know that these symbols
are located in the posgres executable but the loader does not.
I then compiled and installed version 6.5.1 but I get the following
error message when trying to start the Postmaster process:
IpcMemoryCreate: shmget failed (Invalid argument) key=5423001,
size=1073152, permission=600
FATAL 1: ShmemCreate: cannot create region
If somebody has any ideas on how to fix either of these problems, please
let me know.
Thanks
------------------------------------------------------------
David Ouellet Defence Research Establishment
Computer Engineer Val-Cartier
------------------------------------------------------------
