Re: Document the limit on the number of parameters

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 03:01:49
Message-ID: 20180808030149.GE27724@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Greetings Tom,

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> 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.

Ah, I read the original poster as saying that it wasn't in the protocol
docs. If it's there already then I agree, that's sufficient.

Thanks!

Stephen

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2018-08-08 09:16:24 dblink_error_message return value
Previous Message Tom Lane 2018-08-08 02:59:04 Re: Document the limit on the number of parameters