From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
---|---|
To: | Jan Peters <petersjan(at)gmx(dot)at> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Problems with function while migrating from Windows to Linux |
Date: | 2008-04-22 12:30:28 |
Message-ID: | 480DDA64.5030301@postnewspapers.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2008-04-22 12:46:30 | Re: After updating dataset the record goes to the end of the dataset |
Previous Message | Padam J Singh | 2008-04-22 11:02:57 | Re: After updating dataset the record goes to the end of the dataset |