pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedWhy their is a limit in Postgresql (psql) Parameters..?
3+ messages / 3 participants
[nested] [flat]
* Why their is a limit in Postgresql (psql) Parameters..?
@ 2003-07-21 10:29 vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: vijaykumar M @ 2003-07-21 10:29 UTC (permalink / raw)
To: pgsql-sql
<html><div style='background-color:'><DIV>
<P>Hi All,</P>
<P> I'm using Postgresql v7.3.3. I have a small question ...</P>
<P><BR> Why is that there is a maximum limit of 32 input parameters to the<BR>Postgresql function?<BR> Whereas stored procedures in Oracle and SQL Server<BR>take more than 32 input arguments. So this puts extra burden on the<BR>middleware developer to handle this stiuation at the time of migrating<BR>existing databases in SQL Server or Oracle to Postgresql.</P>
<P>Any Info/Suggestions will be highly appreciated.</P>
<P> </P>
<P> </P>
<P><BR><BR><BR><BR> </P></DIV></div><br clear=all><hr>Are you Unmarried? <a href="http://g.msn.com/8HMFENIN/2755??PS=">Register in India's No 1 Matrimony</a> </html>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Why their is a limit in Postgresql (psql) Parameters..?
@ 2003-07-21 11:42 Richard Huxton <richardh@archonet.com>
parent: vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Richard Huxton @ 2003-07-21 11:42 UTC (permalink / raw)
To: vijaykumar M <m_vijaykumar@hotmail.com>; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Why their is a limit in Postgresql (psql) Parameters..?
@ 2003-07-21 13:09 Rod Taylor <rbt@rbt.ca>
parent: Richard Huxton <richardh@archonet.com>
0 siblings, 0 replies; 3+ messages in thread
From: Rod Taylor @ 2003-07-21 13:09 UTC (permalink / raw)
To: Richard Huxton <richardh@archonet.com>; +Cc: vijaykumar M <m_vijaykumar@hotmail.com>; pgsql-sql
> The reason why it's not bigger is that there hasn't been enough people saying
> "I need more parameters".
That and a general speed penalty to all users of all functions.
Make (whatever) the limitation is affect only those using a large number
of parameters and you will find the limit set to a fairly high number.
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-07-21 13:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-21 10:29 Why their is a limit in Postgresql (psql) Parameters..? vijaykumar M <m_vijaykumar@hotmail.com>
2003-07-21 11:42 ` Richard Huxton <richardh@archonet.com>
2003-07-21 13:09 ` Rod Taylor <rbt@rbt.ca>
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