Re: Is there a way to pass more than 32 parameters to a - Mailing list pgsql-general

From scott.marlowe
Subject Re: Is there a way to pass more than 32 parameters to a
Date
Msg-id Pine.LNX.4.33.0307211002380.15882-100000@css120.ihs.com
Whole thread Raw
In response to Is there a way to pass more than 32 parameters to a plpgsql function?  ("Jon Brazus" <jbrazus@computer-systems.com>)
List pgsql-general
On Wed, 16 Jul 2003, Jon Brazus wrote:

>
> Does anyone know of a way to pass more than 32 parameters to a plpgsql
> function?  The 7.3 release documentation states that fuctions can now
> take up to 32 parameters "by default", which implies that perhaps this
> can be changed with a tuning parameter or some such.  Or failing that,
> does anyone know if this limit is going to be increased again in the 7.4
> release?  Any help is appreciated.

sure, you need to edit

pg_config.h.in and change the #define FUNC_MAX_ARGS line to whatever you
want. Then run .configure --yourswtichesgohere and make install.

Note that this requires a dump / restore, if I remember correctly.


pgsql-general by date:

Previous
From: Kathy Zhu
Date:
Subject: Re: Incomprehensible behaviour of a foreign key.
Next
From: "scott.marlowe"
Date:
Subject: Re: Query regarding back up