Обсуждение: plpgsql.dll
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 am I missing something obvious? thanks, --g. ---------------------- http://open.webhop.org ---------------------- ----------------------------------------------------- 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! -----------------------------------------------------
On Thu, Nov 07, 2002 at 12:39:05PM -0000, dag@interfree.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
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@interfree.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! -----------------------------------------------------
On Fri, Nov 08, 2002 at 10:58:15AM -0000, dag@interfree.it wrote: > tkx Jason, You are welcome. > I was missing the cygcrypto&ssl.dll... That's what I thought. 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