Forum OpenACS Q&A: ACS Objects - Creating functions (New - Delete) - Error (exceed number of arguments)

Collapse
1: ACS Objects - Creating functions (New - Delete) - Error (exceed number of arguments)
Posted by garry g on 07/03/03 04:38 PM
I am attepmting to create ACS Objects in my project.  The problem that I am running into is that I created a function that adds a new item, but the number of arguments appears to exceed the maximum allowed of 16.  Am I doing something wrong or is there a reason why it is capped at 16 arguments?  Is there a way of getting around this?  Is this not a common issue?
Collapse
2: Re: ACS Objects - Creating functions (New - Delete) - Error (exceed number of arguments) (response to 1)
Posted by Jade Rubick on 07/03/03 07:18 PM
Unfortunately, Postgres 7.2.x only accept 16 arguments.

There are a couple of ways around this.

1) You can recompile Postgres 7.2, and specify that you want to allow 32 arguments. It's possible, and not too hard.

2) You can install Postgres 7.3.x, which is supposed to work okay for OpenACS. Downside: if you already have an installation, it's hard to upgrade at this point. Someone's working on this.

3) You can create __new functions that accept 16 arguments, and then after you create the row in the table, immediately follow it with an UPDATE statement, which adds in the rest of the information. Put these inside a

db_transaction {

}

statement

Search the forums. This has been asked a couple of times. 😊

Collapse
3: Re: ACS Objects - Creating functions (New - Delete) - Error (exceed number of arguments) (response to 2)
Posted by garry g on 07/03/03 08:02 PM
Jade, sorry for the wasting your time;  I should have did a search prior to posting.

Thank you nonetheless.