Postgres Pro
Downloads
Home   >   mailing lists

number of parameters to a stored procedure - Mailing list pgsql-general

From Steven D. Arnold
Subject number of parameters to a stored procedure
Date
Msg-id 1276386983.20010824014125@neosynapse.net
Whole thread Raw
Responses Re: number of parameters to a stored procedure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hello all,

It is my understanding that 16 parameters are allowed in a stored
procedure.  If this is correct (please advise if not):

1. What are the reasons for this limitation?
2. Are there any plans to increase this number, say to 32 parameters, and
if so, when is this change expected?
3. If there are no imminent plans to support this, would a patch increasing
the number of parameters to 32 be seriously considered?

Thanks in advance!

------------------------------------------------------------------------
Steven D. Arnold                                  stevena@neosynapse.net
AIM: abraxan                                               ICQ: 73804392
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backend message type 0x44 arrived while idle
Next
From: Miroslav Koncar
Date:
Subject: Re: problems transfering databases