Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Subject: Problem with PostgreSQL: createlang plperl
Date: Tue, 13 Jan 2004 17:44:43 +0100
Message-ID: <A5220515092FCE4CAA66663B2FEF094C182B7C@sxmbx03.corproot.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
From: <Juergen DOT Sprenger AT swisscom DOT com>
To: <cygwin AT cygwin DOT com>
X-OriginalArrivalTime: 13 Jan 2004 16:44:44.0077 (UTC) FILETIME=[8C0325D0:01C3D9F4]
X-IsSubscribed: yes
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by delorie.com id i0DGioih005211

Hi,
I tried to install languages into PostgreSQL 7.4.1-2 and ran into the following problem:
 $ createlang plperl
 createlang: language installation failed: ERROR:  could not load library "/usr/lib/postgresql/plperl.dll": dlopen: Win32 error 126

By checking plperl.dll I noticed, that cygperl5_8_0.dll was missing:
 $ cygcheck /usr/lib/postgresql/plperl.dll
 D:/cygwin/lib/postgresql/plperl.dll
   .\postgres.exe
     .\cygcrypto-0.9.7.dll
       .\cygwin1.dll
         C:\windows\System32\KERNEL32.dll
           C:\windows\System32\ntdll.dll
     .\cygcygipc-2.dll
     .\cygssl-0.9.7.dll
 Error: could not find cygperl5_8_0.dll

perl was already installed, but with wrong version (5.8.2-1):
 $ ls /usr/bin/cygperl*
 /usr/bin/cygperl5_8_2.dll

Searched the web but couldn't find an archived perl-5.8.0 package, so I tried to make postgres (tail of logfile):
 make -C pl all
 make[2]: Entering directory `/usr/src/postgresql-7.4.1-2/src/pl'
 make[3]: Entering directory `/usr/src/postgresql-7.4.1-2/src/pl/plpgsql'
 make -C src all
 make[4]: Entering directory `/usr/src/postgresql-7.4.1-2/src/pl/plpgsql/src'
 make[4]: Nothing to be done for `all'.
 make[4]: Leaving directory `/usr/src/postgresql-7.4.1-2/src/pl/plpgsql/src'
 make[3]: Leaving directory `/usr/src/postgresql-7.4.1-2/src/pl/plpgsql'
 make[3]: Entering directory `/usr/src/postgresql-7.4.1-2/src/pl/plperl'
 
 *** Cannot build PL/Perl because libperl is not a shared library.
 *** You might have to rebuild your Perl installation.  Refer to
 *** the documentation for details.
 
 make[3]: Leaving directory `/usr/src/postgresql-7.4.1-2/src/pl/plperl'
 make[3]: Entering directory `/usr/src/postgresql-7.4.1-2/src/pl/plpython'
 
 *** Cannot build PL/Python because libpython is not a shared library.
 *** You might have to rebuild your Python installation.  Refer to
 *** the documentation for details.
 
 make[3]: Leaving directory `/usr/src/postgresql-7.4.1-2/src/pl/plpython'
 make[2]: Leaving directory `/usr/src/postgresql-7.4.1-2/src/pl'
 make[1]: Leaving directory `/usr/src/postgresql-7.4.1-2/src'
 All of PostgreSQL successfully made. Ready to install.

If I did not misunderstand the doc (http://www.perldoc.com/perl5.8.0/README.cygwin.html), libperl is a shared library by default in cygwin environment, and instead of the message which also indicates 'You might have to rebuild your Python installation', plpython runs perfectly well.

Has by chance anyone already solved this problem?

Regards

Juergen

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/