From: Craig Ringer <craig@postnewspapers.com.au>
To: Jan Peters <petersjan@gmx.at>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problems with function while migrating from Windows to Linux
Date: Tue, 22 Apr 2008 20:30:28 +0800
Message-ID: <480DDA64.5030301@postnewspapers.com.au> (raw)
In-Reply-To: <20080422094727.271410@gmx.net>
References: <20080422094727.271410@gmx.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: craig@postnewspapers.com.au, petersjan@gmx.at
Subject: Re: Problems with function while migrating from Windows to Linux
In-Reply-To: <480DDA64.5030301@postnewspapers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox