Re: Problems with function while migrating from Windows to Linux - Mailing list pgsql-sql

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