X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F2CCFD1B53D for ; Mon, 20 Oct 2003 12:43:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 14534-06 for ; Mon, 20 Oct 2003 09:43:31 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 4FC6FD1B52C for ; Mon, 20 Oct 2003 09:43:28 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id h9KChRNw060983 for ; Mon, 20 Oct 2003 12:43:28 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h9KCaVO2059847 for pgsql-sql@postgresql.org; Mon, 20 Oct 2003 12:36:31 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Max input parameter for a function Date: Mon, 20 Oct 2003 08:29:45 -0400 Organization: cbbrowne Computing Inc Lines: 23 Message-ID: References: <008d01c396d3$62d94d60$7502a8c0@hdsc.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) Cancel-Lock: sha1:12VVqhGWcnC+U+YVqr+4m6En6X8= To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/229 X-Sequence-Number: 15629 After a long battle with technology,sgnerd@yahoo.com.sg ("Kumar"), an earthling, wrote: > While trying to allocate about 36 input parameters, I got an error saying that the max input parameter for a function is only 32. > > Is it right? How to overcome this? Because I wanna insert records into a table of 55 columns with a lot of NULL able columns. > > I am using Postgres 7.3.4 on RH Linux 7.2. > > Note: I can't use 2 functions , one to insert 32 rows into the table > first and the update the remaining columns with other > function. Because there are only 27 columns that are not null. The default compiled in is to limit the number of parameters to 32. You can recompile it and modify the number of input parameters. Somehow, the notion of a table with 55 columns strikes me as a situation where normalization is likely to be BADLY needed... -- output = reverse("gro.gultn" "@" "enworbbc") http://www.ntlug.org/~cbbrowne/linux.html Rules of the Evil Overlord #156. "If I have the hero and his party trapped, I will not wait until my Superweapon charges to finish them off if more conventional means are available."