RE: [ADMIN] CREATE LANGUAGE cannot load libra ry ERROR！
Vishal Arora <[email protected]> Thu, 10 Apr 2008 13:57:30 +0530
| Newsgroups | gmane.comp.db.postgresql.admin,gmane.comp.db.postgresql.ports,gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <[email protected]> |
--_4d44a04f-b782-4ad2-8ffc-ad642a81334b_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable set $libdir path in environmental variables in windows.=20 Date: Wed, 9 Apr 2008 00:32:10 +0800From: [email protected]= t: [ADMIN] CREATE LANGUAGE cannot load library ERROR=A3=A1To: pgsql-admin= @postgresql.orgCC: [email protected]; [email protected]= g Hi: =20 I am rather new to PostgreSQL and so have probably done something st= upid (or not done something).=20 I am running PostgreSQL 8.2.7 on Windows 2003 serverr. When I use 'cr= eate language' to add pl/perl to a database, I get the following error: ERROR: could not load library "C:/Program Files/PostgreSQL/8.2/lib/plperl= .dll":The specified module could not be found. =20 However if I look in the directory that it indicates, plperl.dll is a= ctually there, and I do have the full Perl package installed on my system= . I notice that it has the slashes ('/') facing the wrong direction. I have looked for a setting in this regard but can't find one. Is thi= s just the error message or is that actually where it is looking, and ho= w can I fix it? =20 thanks Yawei hou=20 =D1=C5=BB=A2=D3=CA=CF=E4=A3=AC=C4=FA=B5=C4=D6=D5=C9=FA=D3=CA=CF=E4=A3=A1 _________________________________________________________________ Tried the new MSN Messenger? It=A1=AFs cool! Download now. http://messenger.msn.com/Download/Default.aspx?mkt=3Den-in --_4d44a04f-b782-4ad2-8ffc-ad642a81334b_ Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable <html> <head> <style> .hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } </style> </head> <body class=3D'hmmessage'><BR><BR>set $libdir path in environmental varia= bles in windows. <BR><BR> <BLOCKQUOTE> <HR id=3DEC_stopSpelling> Date: Wed, 9 Apr 2008 00:32:10 +0800<BR>From: [email protected]<B= R>Subject: [ADMIN] CREATE LANGUAGE cannot load library ERROR=A3=A1<BR>To:= [email protected]<BR>CC: [email protected]; pgsql-novi= [email protected]<BR><BR> <DIV><FONT size=3D3>Hi:</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D3> I am rather new to PostgreSQ= L and so have probably done something stupid (or not done something).&nbs= p;</FONT></DIV> <DIV><FONT size=3D3><BR> I am running PostgreSQL 8.2.7 = on Windows 2003 serverr. When I use 'create language' to add pl/perl to a= database, I get the following error:</FONT></DIV> <DIV><FONT color=3D#ff0000 size=3D3>ERROR: could not load library "C:/Pro= gram Files/PostgreSQL/8.2/lib/plperl.dll":<BR>The specified module could = not be found.</FONT></DIV> <DIV><FONT color=3D#ff0000 size=3D3></FONT> </DIV> <DIV><FONT size=3D3> However if I look in the directory= that it indicates, plperl.dll is actually there, and I do have the full = Perl package installed on my system. I notice that it has the slashes ('/= ') facing the wrong direction.</FONT></DIV><FONT size=3D3> <DIV><BR> I have looked for a setting in this regard bu= t can't find one. Is this just the error message or is that ac= tually where it is looking, and how can I fix it?</DIV> <DIV> </DIV> <DIV>thanks</DIV> <DIV> &n= bsp; &nb= sp; &nbs= p;  = ; Yawei hou</FONT><BR> </D= IV> <HR SIZE=3D1> <A href=3D"http://cn.mail.yahoo.com/" target=3D_blank>=D1=C5=BB=A2=D3=CA=CF= =E4=A3=AC=C4=FA=B5=C4=D6=D5=C9=FA=D3=CA=CF=E4=A3=A1</A></BLOCKQUOTE><br /= ><hr />Windows Live Spaces : Help your online world come to life, add 500= photos a month. <a href=3D'http://home.services.spaces.live.com/' target= =3D'_new'>Try it!</a></body> </html> --_4d44a04f-b782-4ad2-8ffc-ad642a81334b_--