Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fnEjX-00067f-8w for pgsql-docs@arkaria.postgresql.org; Wed, 08 Aug 2018 03:01:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fnEjV-0008Iy-M4 for pgsql-docs@arkaria.postgresql.org; Wed, 08 Aug 2018 03:01:57 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fnEjV-0008Ir-DN for pgsql-docs@lists.postgresql.org; Wed, 08 Aug 2018 03:01:57 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fnEjO-0006fQ-30 for pgsql-docs@lists.postgresql.org; Wed, 08 Aug 2018 03:01:55 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 825065F79C; Tue, 7 Aug 2018 23:01:49 -0400 (EDT) Date: Tue, 7 Aug 2018 23:01:49 -0400 From: Stephen Frost To: Tom Lane Cc: Bruce Momjian , postgres@kellerer.name, pgsql-docs@lists.postgresql.org Subject: Re: Document the limit on the number of parameters Message-ID: <20180808030149.GE27724@tamriel.snowman.net> References: <153183390829.1395.16339447781418953738@wrigleys.postgresql.org> <20180807215822.GM7297@momjian.us> <20180808020655.GC27724@tamriel.snowman.net> <13394.1533697144@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="hyyaPKn6zvAYX/ai" Content-Disposition: inline In-Reply-To: <13394.1533697144@sss.pgh.pa.us> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --hyyaPKn6zvAYX/ai Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings Tom, * Tom Lane (tgl@sss.pgh.pa.us) wrote: > Stephen Frost writes: > > * Bruce Momjian (bruce@momjian.us) wrote: > >> On Tue, Jul 17, 2018 at 01:25:08PM +0000, PG Doc comments form wrote: > >>> The backend protocol limits the number of parameters that can be pass= ed for > >>> a prepared statement to 32767 (2 byte signed integer). >=20 > >> Uh, is this something people will care about? >=20 > > Seems like a limitation in the backend protocol should probably be > > documented in the backend protocol section of the docs.. >=20 > It is: the definition of the Bind message format says that the parameter > count is an int16. >=20 > The question is whether this deserves to be cross-referenced from > elsewhere. I agree with Bruce that it seems unlikely to be helpful. Ah, I read the original poster as saying that it wasn't in the protocol docs. If it's there already then I agree, that's sufficient. Thanks! Stephen --hyyaPKn6zvAYX/ai Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJbal0dAAoJEO1sijiDR2RVmB8P/2sxlsLxWIPZcJMGh69GTzWr 8BBaSpUKP6Wqdkudb6jrFRID0eoQjC97tupO+5UwjWtkU9mD2FEBSjTzamt0dcHq USxCf9elQYq8S9B0UBLON8AKjj1mqmn1EYnq4JyPh/MS6PaSSrHQlSYs/DqLEUco jbmZpoP+1+xmsYfJ4khxrC9pF9MXfOSvXc2djVGbg4wZVsoKBETKEYtY2tGK//eT J10JhBFkuQUU3VkwyZn7+dxpZX8y8sb0YY+hpmotnbUN2ygVDf/ULN6U/SPA8et2 h4brtp3PDJX5A2ONS9wTDCycTI4R4OrFn1A448D5/OiIhfAGda5w8D/cgcya8pBl 0ckCgRqcTV2NtyWs2V2EmAO0wbzaTAt/JCagVb6mZ6cDWINmrzGEH8UOcJAysI36 KrqIBxMsxsXETYcxALOFvUqEU6xBdToU6R2wIcmeztTGT+6OfspwDjIaniCPGCdW M07mvBK0CMY+vo54e3g1Az8LmlxawP7/tZPWi0eNbsDK3OnOV2pEL/dYX5Assaim jwnFoixp2b0huorjrhJbs03h4v+NbwN6jqxTQO3Ap2rYmtWIW840mfpm4xkuyRju qm5G+qit4R1jQxOoIvIIU1fKVx727GH3itjLytMclaS9zLXlZVEBvKEwANgRzgPA XwhiFylve2QH8xbe5zI1 =x8Pz -----END PGP SIGNATURE----- --hyyaPKn6zvAYX/ai--