Re: create function: number of parameters - Mailing list pgsql-general

From nconway@klamath.dyndns.org (Neil Conway)
Subject Re: create function: number of parameters
Date
Msg-id 20020715224008.GA21752@klamath.dyndns.org
Whole thread Raw
In response to create function: number of parameters  (Ralph Graulich <maillist@shauny.de>)
Responses Re: create function: number of parameters  (Ralph Graulich <maillist@shauny.de>)
List pgsql-general
On Tue, Jul 16, 2002 at 12:23:16AM +0200, Ralph Graulich wrote:
> My problem is, that postgres tells me I can't use more
> than 16 parameters. For those basic "create" functions I need more than 40
> parameters. Is there any easy way to accomplish this or do you have any
> good hints for me?

You can edit FUNC_MAX_ARGS in src/include/pg_config.h, recompile and
re-initdb.

There has been some talk of raising the default setting, but no one
has yet stepped forward with any data on the performance implications
of doing that (or a way to reduce the performance hit, if there is one).

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Ralph Graulich
Date:
Subject: create function: number of parameters
Next
From: Ralph Graulich
Date:
Subject: Re: create function: number of parameters