Michael Paquier <michael.paquier@xxxxxxxxx> writes: > On Wed, Aug 23, 2017 at 3:19 AM, Igor Korot <ikorot01@xxxxxxxxx> wrote: >> [quote] >> PQntuples >> >> Returns the number of rows (tuples) in the query result. Because it >> returns an integer result, large result sets might overflow the return >> value on 32-bit operating systems. >> >> int PQntuples(const PGresult *res); >> [/quote] >> >> Is there another way to not to overflow the result? > Not really with the existing API. Actually, that documentation note is pretty beside-the-point, if not outright wrong. The real issue here is that libpq's internal row counter is also a plain int. As are the rownumber arguments to PQgetvalue and so on. While we could widen that internal counter, it's useless to do so as long as these API choices prevent applications from dealing with resultsets of more than 2G rows. I think what we need is to (1) introduce some error checking in libpq so that it reports an error if the resultset exceeds 2G rows --- right now it'll just crash, I fear, and (2) change the documentation so that this is explained as a library-wide limitation and not just a problem with PQntuples. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
