stat failed on /usr/lib/pgsql/plpgsql.so; no file or directory

From: "Ed Bras" <e(dot)bras(at)hccnet(dot)nl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: stat failed on /usr/lib/pgsql/plpgsql.so; no file or directory
Date: 2000-01-21 01:55:40
Message-ID: 006501bf63b2$9efc5a10$e0ecf1c3@pietjepuik
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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';----

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-01-21 02:07:04 Re: [GENERAL] Datatype serial ?
Previous Message Ed Bras 2000-01-21 01:40:25 Datatype serial ?