Skip site navigation (1) Skip section navigation (2)

Re: plpgsql.dll

From: dag(at)interfree(dot)it ()
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: plpgsql.dll
Date: 2002-11-08 10:58:15
Message-ID: 20021108105815.24402.qmail@community10.interfree.it (view raw or flat)
Thread:
Lists: pgsql-cygwin

tkx Jason,
I didn't know about cygcheck, I was missing the cygcrypto&ssl.dll... 

now it's ok;;


--g.



>On Thu, Nov 07, 2002 at 12:39:05PM -0000, dag(at)interfree(dot)it wrote:
>> hello, I'm trying to use the PL/Python extension (on PG 7.2.3, latest
>> cygwin on win2000), with:
>> 
>> CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
>>   '/lib/postgresql/plpgsql.dll' LANGUAGE 'C';
>> 
>> (the same I did with plpgsql, different dll but same path;)
>> 
>> I get:
>> 
>> ERROR:  Load of file /lib/postgresql/plpython.dll failed: dlopen: Win32 error 
>126
>
>The above error message and the following:
>
>    $ fgrep 126 /usr/include/w32api/winerror.h      #define ERROR_MOD_NOT_FOUND 
>126L
> ...
>
>imply that plpython.dll is failing to load.  I believe that this is because a 
>dependent DLL can not be found:
>
>    $ cygcheck plpython.dll      Found: .\plpython.dll
>    .\plpython.dll
>      C:\cygwin\bin\postgres.exe
>        C:\cygwin\bin\cygwin1.dll
>          C:\WINNT\System32\KERNEL32.dll
>            C:\WINNT\System32\ntdll.dll
>*>    C:\cygwin\bin\libpython2.2.dll
>*>      C:\cygwin\bin\cygcrypto.dll
>*>      C:\cygwin\bin\cygssl.dll
>
>Do you have the above marked DLLs on you system?  Does python work properly from 
>bash?
>
>BTW, the following seem to work OK for me:
>
>    $ psql     Welcome to psql 7.3b3, the PostgreSQL interactive terminal.
>    ...
>    jt=# CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS 
>'/lib/postgresql/plpgsql.dll' LANGUAGE 'C';     CREATE FUNCTION
>    jt=# CREATE FUNCTION plpython_call_handler () RETURNS OPAQUE AS 
>'/lib/postgresql/plpython.dll' LANGUAGE 'C';     CREATE FUNCTION
>
>Jason
>
>-- 
>PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
>Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6
>
>


-----------------------------------------------------

Salve, il messaggio che hai ricevuto
 stato inviato per mezzo del sistema
di web mail interfree. Se anche tu vuoi 
una casella di posta free visita il
sito http://club.interfree.it
Ti aspettiamo!

-----------------------------------------------------



Responses

pgsql-cygwin by date

Next:From: Florian LitotDate: 2002-11-08 11:12:23
Subject: Re: command
Previous:From: Shridhar DaithankarDate: 2002-11-08 10:14:26
Subject: Re: command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group