X-Recipient: archive-cygwin AT delorie DOT com DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id :list-unsubscribe:list-subscribe:list-archive:list-post :list-help:sender:message-id:from:to:subject:date:content-type :content-transfer-encoding:mime-version; q=dns; s=default; b=tB4 aiFSSgo8bo3XM35sXK9oAM0tZ+GjRJng7MFqY246Y9XlfcjrLt7G2fSrRqJy+Sv6 GUxqQSdd5XgDmnpdc39oBFQx5iNDmwjt4Mc7kkl68JT1rCzT5jSgNsQExR+LK/Qm wq5u5YKAXzE4x/Xr7gxd3PsE+ljv/qwF6YjE5kNA= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id :list-unsubscribe:list-subscribe:list-archive:list-post :list-help:sender:message-id:from:to:subject:date:content-type :content-transfer-encoding:mime-version; s=default; bh=ZrZZS0lN/ Dc5/oXE1HuDDF9B9bc=; b=adchuWJGW4050fehn/1Br6a89HPMpl7BWIGCo18mM LXIFIyWrE2CAAvzknKs/+FNY6vLKbKNP9gVxP3EC5KxiEsqYj4trOB9O+vNMV4tF 232m5Zzq1P6gl6C+9zrNwyr74mDZ0t12C88yO/fo8YSuIMZqr/m2J0nVmnL8tRxh aw= Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner AT cygwin DOT com Mail-Followup-To: cygwin AT cygwin DOT com Delivered-To: mailing list cygwin AT cygwin DOT com Authentication-Results: sourceware.org; auth=none X-Virus-Found: No X-Spam-SWARE-Status: No, score=2.5 required=5.0 tests=AWL,BAYES_20,FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,RP_MATCHES_RCVD,SPF_PASS autolearn=ham version=3.3.2 X-HELO: dub0-omc1-s30.dub0.hotmail.com X-TMN: [3xA7aDVQbIx1nJW4tGHLeJ+dq8SGE+/K] Message-ID: From: To: "cygwin AT cygwin DOT com" Subject: 'pgplsh' on Cygwin Date: Thu, 24 Oct 2013 14:17:48 +0000 Content-Type: text/plain; charset="iso-8859-1" MIME-Version: 1.0 X-IsSubscribed: yes Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by delorie.com id r9OEI3bI003285 Hello I am getting 'pgplsh' run under Cygwin PostgreSQL. After minor adjustments to the makefile the library compiles, however I am facing the following error when 'loading' the function definitions in the database: $ psql -d postgres -U SYSTEM -f /usr/local/share/pgplsh/createlang_pgplsh.sql psql:/usr/local/share/pgplsh/createlang_pgplsh.sql:3: ERROR:  could not load library "/usr/local/lib/pgplsh/pgplsh.a": Exec format error psql:/usr/local/share/pgplsh/createlang_pgplsh.sql:7: ERROR:  could not load library "/usr/local/lib/pgplsh/pgplsh.a": Exec format error psql:/usr/local/share/pgplsh/createlang_pgplsh.sql:11: ERROR:  function pg_catalog.plsh_handler() does not exist $ file /usr/local/lib/pgplsh/pgplsh.a /usr/local/lib/pgplsh/pgplsh.a: current ar archive $ file /usr/local/lib/pgplsh/pgplsh.la /usr/local/lib/pgplsh/pgplsh.la: libtool library file, Could someone tide me over this issue? Thanks! Cheers Balazs --- $ cat /usr/local/share/pgplsh/createlang_pgplsh.sql CREATE FUNCTION pg_catalog.plsh_handler() RETURNS language_handler     AS '/usr/local/lib/pgplsh/pgplsh.a'     LANGUAGE C; CREATE FUNCTION pg_catalog.plsh_validator(oid) RETURNS void     AS '/usr/local/lib/pgplsh/pgplsh.a'     LANGUAGE C; CREATE LANGUAGE plsh     HANDLER pg_catalog.plsh_handler     VALIDATOR pg_catalog.plsh_validator; -- Problem reports: http://cygwin.com/problems.html FAQ: http://cygwin.com/faq/ Documentation: http://cygwin.com/docs.html Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple