Forums PostgreSQL.fr

parora0124

Membre

Change the value of max_function_arg

Hi again,

I have a Stored Proc in PostgreSQL which now has more than 100 args. When I try to create this STP, I get an error "ERROR: functions cannot have more than 100 arguments".

I see that there is a Preset Option called "max_function_args" whose value is set to 100 by default.

Can someone tell me how to change the value of this "max_function_args" parameter (if possible) so that I can create the stored proc OR any other way to do the same?

Thanks.

rjuju

Administrateur

Re : Change the value of max_function_arg

Hello,

You cannot change this parameter without recompiling postgres.  I'd not recommand to do it though.  If you need more than 100 parameters in your function, you should probably try to think of a better design to achieve your need.  As a blind guess, I'd say to get all the needed information from your table(s), and reduce parameters to the PK(s) and some few additional parameters.

---

Julien.
https://rjuju.github.io/

parora0124

Membre

Re : Change the value of max_function_arg

Sounds good rjuju .. Thanks again