Skip site navigation (1) Skip section navigation (2)

Re: [SQL] 16 parameter limit

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: peter_e(at)gmx(dot)net, pgman(at)candle(dot)pha(dot)pa(dot)us, tgl(at)sss(dot)pgh(dot)pa(dot)us,josh(at)agliodbs(dot)com, jproctor(at)prium(dot)net, pgsql-patches(at)postgresql(dot)org
Subject: Re: [SQL] 16 parameter limit
Date: 2002-04-16 03:52:16
Message-ID: 20020415235216.5bdf393a.nconway@klamath.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-sql
On Tue, 16 Apr 2002 11:35:57 +0800
"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> wrote:
> > > Are we staying at 16 as the default?   I personally think we can
> > > increase it to 32 with little penalty,
> >
> > If you want to increase it, let's just increase it and not add any more
> > configure options.  If someone wants more than 32 then we really need to
> > start talking about design issues.
> 
> Why not give them the configure option?  It's not good HCI to impose
> arbitrary limits on people...?

It's not an arbitrary limit -- users can easily change pg_config.h.

> We can default it to 32, since there's demand for it.  If a particular user
> decided to configure it higher, then they do that knowing that it may cause
> performance degradation.  It's good to give them that choice though.

What if someone actually uses functions with more than 32
arguments? Their code will not longer be portable among
PostgreSQL installations, and they'll need to get the local
admin to recompile.

I could see adding a configure option if there was a justifiable
reason for using functions with more than 32 arguments -- but
IMHO that is quite a bizarre situation anyway, as Peter said.

My vote is to set the default # of function args to some
reasonable default (32 sounds good), and leave it at that.

Cheers,

Neil

-- 
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2002-04-16 03:57:04
Subject: Re: [SQL] 16 parameter limit
Previous:From: Bruce MomjianDate: 2002-04-16 03:51:31
Subject: Re: ANSI Compliant Inserts

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2002-04-16 03:57:04
Subject: Re: [SQL] 16 parameter limit
Previous:From: Bruce MomjianDate: 2002-04-16 03:51:31
Subject: Re: ANSI Compliant Inserts

pgsql-sql by date

Next:From: Christopher Kings-LynneDate: 2002-04-16 03:57:04
Subject: Re: [SQL] 16 parameter limit
Previous:From: Christopher Kings-LynneDate: 2002-04-16 03:49:30
Subject: Re: [PATCHES] [SQL] 16 parameter limit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group