Re: Document the limit on the number of parameters

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: 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-08 02:06:55
Message-ID: 20180808020655.GC27724@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Greetings,

* Bruce Momjian (bruce(at)momjian(dot)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:
> >
> > 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?

Seems like a limitation in the backend protocol should probably be
documented in the backend protocol section of the docs..

Thanks!

Stephen

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2018-08-08 02:59:04 Re: Document the limit on the number of parameters
Previous Message Bruce Momjian 2018-08-07 22:54:26 Re: decimal digits precision for real and double precision types