Re: parameter limit - Mailing list pgsql-general

On 4/23/20 7:33 AM, Scott Ribe wrote:
> In libpq, PQexecParams has nParams as type int. So on any reasonable platform, that's at least 4 bytes. My question
thenis: when I see documented limits of 65535 params in various drivers and libraries, that is NOT a restriction of
libpqnor of the protocol, but rather an arbitrary limit of the driver/library, correct?
 

No.

From:

src/interfaces/libpq/fe-exec.c

if (nParams < 0 || nParams > 65535)
         {
                 printfPQExpBuffer(&conn->errorMessage,
                                                   libpq_gettext("number 
of parameters must be between 0 and 65535\n"));
                 return 0;
         }

> 
> --
> Scott Ribe
> scott_ribe@elevated-dev.com
> https://www.linkedin.com/in/scottribe/
> 
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com