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
