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 1fn9zs-0007rE-PC for pgsql-docs@arkaria.postgresql.org; Tue, 07 Aug 2018 21:58:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fn9zq-0005oZ-Qb for pgsql-docs@arkaria.postgresql.org; Tue, 07 Aug 2018 21:58:30 +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 1fn9zq-0005oS-Hb for pgsql-docs@lists.postgresql.org; Tue, 07 Aug 2018 21:58:30 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fn9zj-0008Qg-Gn for pgsql-docs@lists.postgresql.org; Tue, 07 Aug 2018 21:58:29 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1fn9zi-0000YS-BD; Tue, 07 Aug 2018 17:58:22 -0400 Date: Tue, 7 Aug 2018 17:58:22 -0400 From: Bruce Momjian To: postgres@kellerer.name, pgsql-docs@lists.postgresql.org Subject: Re: Document the limit on the number of parameters Message-ID: <20180807215822.GM7297@momjian.us> References: <153183390829.1395.16339447781418953738@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <153183390829.1395.16339447781418953738@wrigleys.postgresql.org> User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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: > > Page: https://www.postgresql.org/docs/10/static/sql-prepare.html > Description: > > The backend protocol limits the number of parameters that can be passed for > a prepared statement to 32767 (2 byte signed integer). > > 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. > > I did not find anything in the chapter about PREPARE > https://www.postgresql.org/docs/current/static/sql-prepare.html or about the > backend protocol: > https://www.postgresql.org/docs/current/static/protocol.html nor on the FAQ > page: https://wiki.postgresql.org/wiki/FAQ Uh, is this something people will care about? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +