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
sup****t EXECUTE ... INTO .
--
Craig Ringer
--
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
|
