Re: Functions have 32 args limt ??? - Mailing list pgsql-general

From Joe Conway
Subject Re: Functions have 32 args limt ???
Date
Msg-id 3F4D8DE0.1060307@joeconway.com
Whole thread Raw
In response to Functions have 32 args limt ???  ("Ivar" <ivar@lumisoft.ee>)
List pgsql-general
Ivar wrote:
> For my supprise I found that functions have 32 parameter limit.
>
> Where to find more info about this limitation or similar limitations ?
>
> I need at least 50, 100 would be ok.

See INDEX_MAX_KEYS defined in src/include/pg_config.h.in
(pg_config_manual.h in postgres 7.4). Change to 64 or whatever and
recompile. But note that you'll need to dump, initdb, and reload your
data. Also note that there are performance and disk usage tradeoffs --
search the mailing list archives from August 2002 for some test results
and discussion.

Joe


pgsql-general by date:

Previous
From: "Andrew L. Gould"
Date:
Subject: Re: Question Join/Subselect
Next
From: "K. Suresh"
Date:
Subject: mysql to pgsqwl migration