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

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. 😊

Jade, sorry for the wasting your time;  I should have did a search prior to posting.

Thank you nonetheless.