Re: [GENERAL] RE: stat failed on /usr/lib/pgsql/plpgsql.so; no file or directory

Hello Ed,

Once, Friday, January 21, 2000, 11:47:07 PM, you wrote:

EB> I can do a ls /usr/lib/pgsql/plpgsql.so with no problem.
EB> By the way:
EB> 1: I am using Red hat 6.0 with kernel 2.2.52.
EB> 2: What shloud be the rights and the ownership of the plpgsql file and those
EB> of the directories where it in ? (I haven't changed any of these after the
EB> installation).

EB> Please let me know if anyone has any ideas ?

EB> Regards,
EB> Ed Bras


EB> -----Original Message-----
EB> From: mack@ips.cs.tu-bs.de [mailto:mack@ips.cs.tu-bs.de]
EB> Sent: vrijdag 21 januari 2000 14:24
EB> To: e.bras@hccnet.nl
EB> Subject: Re: stat failed on /usr/lib/pgsql/plpgsql.so; no file or
EB> directory


>> I am using psql for about the first time and created some tables and
EB> 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)
EB> with neither an error.
>>
>> However when I ecxute a very simple short function which has the language
EB> set to plpgsql it gives me the following error: "stat failed on
EB> /usr/lib/pgsql/plpgsql.so; no file or directory"
>>
EB> Try: ls /usr/lib/pgsql/plpgsql.so as user postgres.
EB> If it doesn't show you the file, the problem should be clear.

EB> Otherwise? Don't know for the moment...

EB> Thomas Mack
EB> TU Braunschweig, Abt. Informationssysteme


EB> ************

I had the same problem and I resolved it by changing mklang_pl.sql
file in /usr/lib/postgresql/lib. I have changed there path to
plpgsql.so, there was something like

create function plpgsql_call_handler() returns opaque
        as '$POSTGRESDIR/plpgsql.so'
        language 'C';

and I have changed this to

create function plpgsql_call_handler() returns opaque
        as '/usr/lib/postgresql/lib/plpgsql.so'
        language 'C';

and then droped pgsql language and reran mklang_pl.sql

Best regards,
 Yury  ICQ 11831432
 mailto:yura@vpcit.ru