parameter limit

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: parameter limit
Date: 2020-04-23 14:33:20
Message-ID: 0A6380C4-E0E0-4554-B98C-0889CF03C4C1@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In libpq, PQexecParams has nParams as type int. So on any reasonable platform, that's at least 4 bytes. My question then is: when I see documented limits of 65535 params in various drivers and libraries, that is NOT a restriction of libpq nor of the protocol, but rather an arbitrary limit of the driver/library, correct?

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
https://www.linkedin.com/in/scottribe/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-04-23 14:48:27 Re: parameter limit
Previous Message Michael Lewis 2020-04-23 13:16:52 Re: pg11: Query using index, but only for half the partitions