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:date:from:mime-version:to:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	 q=dns; s=default; b=O7s9tBcrfWytqVe23NJXmchtdoT17b4xGAGCqQaEGVQ
	JF/6SS2VoOhxZuXYTxKsKxVR/l7JFVLpHyUkaIMRE8dRgLTlJt+cFCVljHebEiPj
	jJlpfxpyYWuffja0V14O70XUejo5N6IvfZAN4vjMjRGePvtkGuXBH+3GouR5I1zE
	=
Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm
Sender: cygwin-owner@cygwin.com
Mail-Followup-To: cygwin@cygwin.com
Message-ID: <52693A98.3080902@gmail.com>
Date: Thu, 24 Oct 2013 17:19:52 +0200
From: marco atzeri <marco.atzeri@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.0.1
MIME-Version: 1.0
To: cygwin@cygwin.com
Subject: Re: 'pgplsh' on Cygwin
References: <DUB126-W40D94C295FABE0CA351F6EA90C0@phx.gbl>
In-Reply-To: <DUB126-W40D94C295FABE0CA351F6EA90C0@phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Il 10/24/2013 4:17 PM, sbremal@hotmail.com ha scritto:
> 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

some info more about how you built pgplsh ?


trying to load a static lib looks wrong...

>
> ---
>
> $ 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