Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id EEC192E0048
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Tue, 22 Apr 2008 09:30:48 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 18591-05
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Tue, 22 Apr 2008 09:30:38 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from www.postnewspapers.com.au (www.postnewspapers.com.au
	[202.61.230.242])
	by developer.postgresql.org (Postfix) with ESMTP id 157E42E0046
	for <pgsql-sql@postgresql.org>; Tue, 22 Apr 2008 09:30:46 -0300 (ADT)
Received: from mail.postnewspapers.com.au
	(202-89-185-120.static.dsl.amnet.net.au [202.89.185.120])
	by www.postnewspapers.com.au (Postfix) with ESMTP id 973DFD55D7;
	Tue, 22 Apr 2008 20:30:40 +0800 (WST)
Received: from localhost (access [127.0.0.1])
	by mail.postnewspapers.com.au (Postfix) with ESMTP id B8A021E0435;
	Tue, 22 Apr 2008 20:30:43 +0800 (WST)
X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au
Received: from mail.postnewspapers.com.au ([127.0.0.1])
	by localhost (access.postnewspapers.com.au [127.0.0.1]) (amavisd-new,
	port 10024)
	with LMTP id dB7hx-j9BV7B; Tue, 22 Apr 2008 20:30:43 +0800 (WST)
Received: from [203.161.97.213] (203.161.97.213.static.amnet.net.au
	[203.161.97.213])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(Client CN "Craig Ringer",
	Issuer "POST Certificate Authority" (verified OK))
	by mail.postnewspapers.com.au (Postfix) with ESMTP id D7ADA1E0434;
	Tue, 22 Apr 2008 20:30:42 +0800 (WST)
Message-ID: <480DDA64.5030301@postnewspapers.com.au>
Date: Tue, 22 Apr 2008 20:30:28 +0800
From: Craig Ringer <craig@postnewspapers.com.au>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: Jan Peters <petersjan@gmx.at>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problems with function while migrating from Windows to
 Linux
References: <20080422094727.271410@gmx.net>
In-Reply-To: <20080422094727.271410@gmx.net>
X-Enigmail-Version: 0.95.6
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/137
X-Sequence-Number: 30676

Jan Peters wrote:
> Hello list,
> after developping my application in a Windows environment I am now migrating to the production Linux webserver.
>   
[snip]
> when I do e.g. a "select getgv_neu(5,'company_5',1,0)" I get the error message:
>
> ERROR:  syntax error at or near "$4" at character 81
> QUERY:  SELECT  'SELECT getaktiva(' ||  $1 || ',' ||  $2  || ',' ||  $3  || ') ;' INTO  $4
> CONTEXT:  PL/pgSQL function "getgv_neu" line 7 at execute statement
>
> What might be the problem here? Any ideas? I am stuck...
>   
At a guesss, you were using PostgreSQL 8.3 under Windows and the 
production Linux system has PostgreSQL 8.2 or earlier, which does not 
support EXECUTE ... INTO .

--
Craig Ringer