Skip site navigation (1) Skip section navigation (2)

Re: Cannot Create plpqsql function!

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: asreddy <asreddy(at)procti(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Cannot Create plpqsql function!
Date: 2001-04-26 12:50:02
Message-ID: 3AE8197A.ABBADEB9@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-bugs
> Using postgresql 6.5.2 on RedHat linux 6.1. Getting the following
> error while creating function:
> ERROR:  Procedures cannot take more than 8 arguments
> Any pointers? Do not tell me to go for version 7. I may not have that
> time to go for a change.

You have two choices: 
1) do the Thing Which Cannot Be Mentioned, or
2) stop trying to create functions with more than 8 arguments

PostgreSQL (at least for 6.5.x) had an 8-member array defined to hold
function arguments, and afaik it is a hard upper limit. Much easier to
do (1) than to try to recode the 6.5.x backend to accomodate it.

                    - Thomas

In response to

pgsql-bugs by date

Next:From: Oscar FRANCOISDate: 2001-04-26 13:02:27
Subject: JDBC Driver Class: Connection Method: isClosed() error
Previous:From: pgsql-bugsDate: 2001-04-26 11:05:16
Subject: pg7.0.2 doesnt yield match on regexps w/ many "|"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group