From m_vijaykumar@hotmail.com Mon Jul 21 10:29:49 2003 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id C19CDD1C4CB for ; Mon, 21 Jul 2003 10:29:49 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 00308-01 for ; Mon, 21 Jul 2003 10:29:48 +0000 (GMT) Received: from hotmail.com (bay2-f69.bay2.hotmail.com [65.54.247.69]) by svr1.postgresql.org (Postfix) with ESMTP id 4BCC2D1C4CA for ; Mon, 21 Jul 2003 07:29:48 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 21 Jul 2003 03:29:50 -0700 Received: from 202.63.107.19 by by2fd.bay2.hotmail.msn.com with HTTP; Mon, 21 Jul 2003 10:29:50 GMT X-Originating-IP: [202.63.107.19] X-Originating-Email: [m_vijaykumar@hotmail.com] From: "vijaykumar M" To: pgsql-sql@postgresql.org Subject: Why their is a limit in Postgresql (psql) Parameters..? Date: Mon, 21 Jul 2003 10:29:50 +0000 Mime-Version: 1.0 Content-Type: text/html Message-ID: X-OriginalArrivalTime: 21 Jul 2003 10:29:50.0674 (UTC) FILETIME=[04323B20:01C34F73] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/302 X-Sequence-Number: 14416

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.

Any Info/Suggestions will be highly appreciated.

 

 





 


Are you Unmarried? Register in India's No 1 Matrimony From richardh@archonet.com Mon Jul 21 11:42:52 2003 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 95E91D1C4CA for ; Mon, 21 Jul 2003 11:42:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 05932-05 for ; Mon, 21 Jul 2003 11:42:50 +0000 (GMT) Received: from anchor-post-39.mail.demon.net (anchor-post-39.mail.demon.net [194.217.242.80]) by svr1.postgresql.org (Postfix) with ESMTP id 68420D1C4C8 for ; Mon, 21 Jul 2003 08:42:50 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-39.mail.demon.net with esmtp (Exim 3.36 #2) id 19eZ48-0006GO-0U; Mon, 21 Jul 2003 12:42:53 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id BE49D1786A; Mon, 21 Jul 2003 12:42:51 +0100 (BST) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 1FACA1785A; Mon, 21 Jul 2003 12:42:51 +0100 (BST) From: Richard Huxton To: "vijaykumar M" , pgsql-sql@postgresql.org Subject: Re: Why their is a limit in Postgresql (psql) Parameters..? Date: Mon, 21 Jul 2003 12:42:49 +0100 User-Agent: KMail/1.5 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200307211242.49263.richardh@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/304 X-Sequence-Number: 14418 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 rbt@rbt.ca Mon Jul 21 13:08:37 2003 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id A94CCD1C510 for ; Mon, 21 Jul 2003 13:08:37 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 16091-08 for ; Mon, 21 Jul 2003 13:08:35 +0000 (GMT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 820D9D1C4B7 for ; Mon, 21 Jul 2003 10:08:35 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id DB1C710258; Mon, 21 Jul 2003 09:01:39 -0400 (EDT) Received: from [192.168.1.200] (dyn-133-81.tor.dsl.tht.net [134.22.133.81]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 901091024D; Mon, 21 Jul 2003 09:01:37 -0400 (EDT) Subject: Re: Why their is a limit in Postgresql (psql) Parameters..? From: Rod Taylor To: Richard Huxton Cc: vijaykumar M , pgsql-sql@postgresql.org In-Reply-To: <200307211242.49263.richardh@archonet.com> References: <200307211242.49263.richardh@archonet.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-Yt/+RUuUG2lLKT8V11Cr" Message-Id: <1058792958.30101.20.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 21 Jul 2003 13:09:18 +0000 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/306 X-Sequence-Number: 14420 --=-Yt/+RUuUG2lLKT8V11Cr Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > The reason why it's not bigger is that there hasn't been enough people sa= ying=20 > "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. --=-Yt/+RUuUG2lLKT8V11Cr Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA/G+X96DETLow6vwwRAkTBAJwOLTG8C/mS/B8z4iGOkNp+vZZ6vACfRjKN cGz9x1vBirfv4BXLN5VHrew= =52FK -----END PGP SIGNATURE----- --=-Yt/+RUuUG2lLKT8V11Cr--