From: Richard Huxton <richardh@archonet.com>
To: vijaykumar M <m_vijaykumar@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Why their is a limit in Postgresql (psql) Parameters..?
Date: Mon, 21 Jul 2003 12:42:49 +0100
Message-ID: <200307211242.49263.richardh@archonet.com> (raw)
In-Reply-To: <BAY2-F69ACkWHZqYW8B00007b50@hotmail.com>
References: <BAY2-F69ACkWHZqYW8B00007b50@hotmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: richardh@archonet.com, m_vijaykumar@hotmail.com
Subject: Re: Why their is a limit in Postgresql (psql) Parameters..?
In-Reply-To: <200307211242.49263.richardh@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox