Re: plpython

Oliver,

On Thu, Jan 09, 2003 at 05:38:50PM +0100, Oliver Vecernik wrote:
> I downloaded the latest release of cygwin (1.3.18-1) with pgsql 7.3.1
                                                                  ^^^^^

Is the above a private build of PostgreSQL 7.3.1 or the official Cygwin
PostgreSQL 7.3-1 package?

> $ createlang plpython test
> ERROR:  Load of file /usr/lib/postgresql/plpython.dll failed: dlopen:
> Win32 error 126
> createlang: language installation failed

I don't get the above error:

    $ createlang -U postgres plpython template1
    $

> Any ideas?

The above error usually occurs when a dependent DLL cannot be found:

    $ fgrep 126L /usr/include/w32api/winerror.h
    #define ERROR_MOD_NOT_FOUND 126L
    ...

Note the following:

    $ cygcheck $(cygpath -w /usr/lib/postgresql/plpython.dll)
    C:\cygwin\lib\postgresql\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
                             ^^^

Are you running a private build of Python 2.3a1 or the official Cygwin
Python 2.2.2-4 package?  If the former, then this would explain the
error.

However, the most recent Cygwin Python package (i.e., 2.2.2-4) was built
with a shared _socket module:

    http://cygwin.com/ml/cygwin-announce/2003-01/msg00003.html

and plpython in the PostgreSQL 7.3-1 package was built against a Cygwin
Python with a static _socket module.  I was concerned that this would
cause problems, but the above successful createlang seems to indicate
otherwise.

Nevertheless, I am building PostgreSQL 7.3.1 now and will release Cygwin
PostgreSQL 7.3.1-1 ASAP.

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