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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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