Igor Korot <ikorot01@xxxxxxxxx> writes: > On Thu, Aug 24, 2017 at 8:51 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> 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. > Does this mean that querying a table with a big number of rows will > crash the psql? I haven't tried it, but it sure looks like it would, if you don't hit OOM first. pqAddTuple() isn't doing anything to guard against integer overflow. The lack of reports implies that no one has ever tried to retrieve even 1G rows, let alone more ... 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
