Re: create function: number of parameters

From: nconway(at)klamath(dot)dyndns(dot)org (Neil Conway)
To: Ralph Graulich <maillist(at)shauny(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: create function: number of parameters
Date: 2002-07-15 22:40:08
Message-ID: 20020715224008.GA21752@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ralph Graulich 2002-07-15 23:07:21 Re: create function: number of parameters
Previous Message Christopher Weimann 2002-07-15 22:33:19 Re: MySQL vs. PostgreSQL