I am using psql for about the first time and created some tables and triggers with their functions written in PL/pgSQL... No errors so far.
I loaded the plpgsql.so (which I wrote down at het bottom of the mail) with neither an error.
However when I ecxute a very simple short function which has the language set to plpgsql it gives me the following error: "stat failed on /usr/lib/pgsql/plpgsql.so; no file or directory"
Anyone an idea what the problem is ?? The directory /usr/lib/pgsql/ excits but has the owner set to root. I changed the owner of the file to postgres, but as postgres executing the small program it still gave me the same error (postgres had read and write error to the file but not to the directory)
It is probably a "right error" but which rights should I give the directory without everyone accessing them ?
But when it can locate the file, then why doen't it give the same error when you declare the pl/pgsql handler ?
Can someone tell me where he has this file located and who are the owner of the file and path as well as the rights ?
I noticed that in the example in the documentation they locate the plpgsql.so file in /usr/local/pgsql/lib/, which is not were it resides on my machine !!
Regards,
Ed Bras
CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
'/usr/lib/pgsql/plpgsql.so ' LANGUAGE 'C';
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
HANDLER plpgsql_call_handler
LANCOMPILER 'PL/pgSQL';----