help ?: "stat failed on /usr/lib/pgsql/plpgsql.so; no file or directory" ??? - Mailing list pgsql-general

From Ed Bras
Subject help ?: "stat failed on /usr/lib/pgsql/plpgsql.so; no file or directory" ???
Date
Msg-id 004801bf63b0$603fefa0$e0ecf1c3@pietjepuik
Whole thread Raw
List pgsql-general

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';----

pgsql-general by date:

Previous
From: Sarah Officer
Date:
Subject: Re: < and > for datetime
Next
From: "Ed Bras"
Date:
Subject: Where is the Database log file ?