Re: plpgsql.dll

From: Jason Tishler <jason(at)tishler(dot)net>
To: dag(at)interfree(dot)it
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: plpgsql.dll
Date: 2002-11-07 13:18:24
Message-ID: 20021107131823.GC1820@tishler.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

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

In response to

Browse pgsql-cygwin by date

  From Date Subject
Next Message Jason Tishler 2002-11-07 13:42:48 Re: [HACKERS] Request for supported platforms
Previous Message Florian Litot 2002-11-07 13:13:43 Re: trace