From: | Richard Huxton <richardh(at)archonet(dot)com> |
---|---|
To: | "vijaykumar M" <m_vijaykumar(at)hotmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Why their is a limit in Postgresql (psql) Parameters..? |
Date: | 2003-07-21 11:42:49 |
Message-ID: | 200307211242.49263.richardh@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Monday 21 July 2003 11:29, vijaykumar M wrote:
> Hi All,
>
> I'm using Postgresql v7.3.3. I have a small question ...
>
> Why is that there is a maximum limit of 32 input parameters to the
> Postgresql function?
> Whereas stored procedures in Oracle and SQL Server
> take more than 32 input arguments. So this puts extra burden on the
> middleware developer to handle this stiuation at the time of migrating
> existing databases in SQL Server or Oracle to Postgresql.
It used to be 16 and was increased to 32 fairly recently (hmm - 7.3.0
according to the release notes). People used to tweak and recompile the
source to increase from 16, so I suppose you could still do the same. Have a
look in the mailing list archives, I seem to remember messages on this in the
past.
The reason why it's not bigger is that there hasn't been enough people saying
"I need more parameters".
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-07-21 11:46:02 | Re: How to write this query! |
Previous Message | vijaykumar M | 2003-07-21 10:29:50 | Why their is a limit in Postgresql (psql) Parameters..? |