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 1fnDsP-0003PB-Dn for pgsql-docs@arkaria.postgresql.org; Wed, 08 Aug 2018 02:07:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fnDsN-0003hJ-9t for pgsql-docs@arkaria.postgresql.org; Wed, 08 Aug 2018 02:07:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fnDsN-0003hC-4V for pgsql-docs@lists.postgresql.org; Wed, 08 Aug 2018 02:07:03 +0000 Received: from tamriel.snowman.net ([96.255.250.162]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fnDsH-0001Qv-8H for pgsql-docs@lists.postgresql.org; Wed, 08 Aug 2018 02:07:02 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id B900F5F79C; Tue, 7 Aug 2018 22:06:55 -0400 (EDT) Date: Tue, 7 Aug 2018 22:06:55 -0400 From: Stephen Frost To: Bruce Momjian Cc: postgres@kellerer.name, pgsql-docs@lists.postgresql.org Subject: Re: Document the limit on the number of parameters Message-ID: <20180808020655.GC27724@tamriel.snowman.net> References: <153183390829.1395.16339447781418953738@wrigleys.postgresql.org> <20180807215822.GM7297@momjian.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Q4cBrG/14hV1V+He" Content-Disposition: inline In-Reply-To: <20180807215822.GM7297@momjian.us> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Q4cBrG/14hV1V+He Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Bruce Momjian (bruce@momjian.us) wrote: > On Tue, Jul 17, 2018 at 01:25:08PM +0000, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > >=20 > > Page: https://www.postgresql.org/docs/10/static/sql-prepare.html > > Description: > >=20 > > The backend protocol limits the number of parameters that can be passed= for > > a prepared statement to 32767 (2 byte signed integer). > >=20 > > As that is something that is independent of the client library, I think= this > > should be documented in the user facing manual for the Postgres server > > somewhere.=20 > >=20 > > I did not find anything in the chapter about PREPARE > > https://www.postgresql.org/docs/current/static/sql-prepare.html or abou= t the > > backend protocol: > > https://www.postgresql.org/docs/current/static/protocol.html nor on the= FAQ > > page: https://wiki.postgresql.org/wiki/FAQ >=20 > Uh, is this something people will care about? Seems like a limitation in the backend protocol should probably be documented in the backend protocol section of the docs.. Thanks! Stephen --Q4cBrG/14hV1V+He Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJbalA/AAoJEO1sijiDR2RVL2wP/0r09ZhfwRfbp0ML3j/asA47 JmCNQCAh+lhSDwGn7XZ4WTT3cRRcKkgAaEQVec0yYVLZKev3huK0ScrkJg1GD24O uMHLS2g3mBPcv0LHi4hsS+bYFYWmIyzUkVnHnsIa1bM1S232kIrzILNH1shQsJzQ Rr4G8cvpIqAutsvFmjJl1gk+U6V/uk3KNGWoU2aik6z9Ieo1s3eDiAhKlIw/jk+J WiG6ci0xmFRYWT38EwIbXyZszmOvqatRDeEhu008mIznijHFHStB4mtrY2kuJ1+g irKJtb9c1Bj1m8zWqMHDnMGMOE46LcpJqkF0TOpif0t+jjNwwtS+mFIqhbiY0s8b UKCO5f1yWuTbX22c0vJ5HIACOzg1jBfxWwoAZxB0CTFeH9OMXyOn9G11K3SoFjsO pEJ8cWEQ57nncGl6VAAeLERWoA7b/BidptLOcJidvENtPnjSfhXJQv+/R+63TroR 0nT4G2KvoxRFgnq3pOxveV0yG/Hx9vRsD5txp6HAOWqYPUrapZZdc7lJB9db3L4f OdPNS2Ou2gcAG2ScbcfzvpLvHwZOjBQv3thSUVUviv4ZCSwsunM9yLDDmEL4NJUa 7wSiJ8HJShhGyyL4Yp28A/HBFDlKZtJiKafHraarLZ1rmWRMQlvTMk/MFXlGgnJi +J6RkEw2aZdQc0Zx7WO7 =K/dV -----END PGP SIGNATURE----- --Q4cBrG/14hV1V+He--