Re: Document the limit on the number of parameters

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: postgres(at)kellerer(dot)name, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Document the limit on the number of parameters
Date: 2018-08-07 21:58:22
Message-ID: 20180807215822.GM7297@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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 <bruce(at)momjian(dot)us> 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 +

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Richard Swagerman 2018-08-07 22:21:40 how to modify the navfooter
Previous Message Bruce Momjian 2018-08-07 17:57:42 Re: RETURN NULL in the sample of insert trigger on partitioned table