PostgreSQL La base de donnees la plus sophistiquee au monde.

Forums PostgreSQL.fr

Le forum officiel de la communauté francophone de PostgreSQL

Vous n'êtes pas identifié(e).

#1 01/11/2016 20:41:42

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.

Hors ligne

#2 02/11/2016 19:30:34

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.

Hors ligne

#3 02/11/2016 20:24:33

parora0124
Membre

Re : Change the value of max_function_arg

Sounds good rjuju .. Thanks again

Hors ligne

Pied de page des forums