Re: Document the limit on the number of parameters

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, 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:59:04
Message-ID: 13394.1533697144@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Stephen Frost <sfrost(at)snowman(dot)net> writes:
> * Bruce Momjian (bruce(at)momjian(dot)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 passed for
>>> a prepared statement to 32767 (2 byte signed integer).

>> 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..

It is: the definition of the Bind message format says that the parameter
count is an int16.

The question is whether this deserves to be cross-referenced from
elsewhere. I agree with Bruce that it seems unlikely to be helpful.

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Stephen Frost 2018-08-08 03:01:49 Re: Document the limit on the number of parameters
Previous Message Stephen Frost 2018-08-08 02:06:55 Re: Document the limit on the number of parameters