From: | "Bohdan Linda" <bohdan(dot)linda(at)seznam(dot)cz> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1832: Can't create function in plpgsql which has more than 10 parameters |
Date: | 2005-08-18 12:47:56 |
Message-ID: | 20050818124756.79588F0C13@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1832
Logged by: Bohdan Linda
Email address: bohdan(dot)linda(at)seznam(dot)cz
PostgreSQL version: 7.3.4
Operating system: Solaris
Description: Can't create function in plpgsql which has more than 10
parameters
Details:
I have found if I will create functions as:
CREATE OR REPLACE FUNCTION addSyslog (
VARCHAR
,VARCHAR(50)
,INET
,TIMESTAMP
,VARCHAR(255)
,NUMERIC(5)
,NUMERIC
,INET
,INTEGER
,INET
,INTEGER
) RETURNS INTEGER AS '
DECLARE
BEGIN
RETURN 1;
END
' LANGUAGE 'plpgsql';
and I will try to call:
SELECT
addSyslog('StrA','Strb','100.100.100.100','2005-08-17
12:24:37.545024','aaaaa log
message',555,87923463,'192.168.0.1',0,'192.168.0.2',0);
I will get:
WARNING: plpgsql: ERROR during compile of addsyslog near line 3
ERROR: syntax error at or near ","
But if I call:
SELECT
addSyslog('StrA','Strb','100.100.100.100','2005-08-17
12:24:37.545024','aaaaa log
message',555,87923463,'192.168.0.1',0,'192.168.0.2');
everything goes well. I shall be able to pass more than 10 parameters.
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2005-08-18 14:43:36 | Re: [GENERAL] pgsql-bugs |
Previous Message | Michael Fuhr | 2005-08-18 05:37:58 | Re: BUG #1831: plperl gives error after reconnect. |