| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com> |
| Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Retrieving query results |
| Date: | 2017-08-24 14:56:33 |
| Message-ID: | 14978.1503586593@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Igor Korot <ikorot01(at)gmail(dot)com> writes:
> On Thu, Aug 24, 2017 at 8:51 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2017-08-24 15:09:39 | Re: DROP [TEMP] TABLE syntax, as reason why not? |
| Previous Message | Igor Korot | 2017-08-24 13:47:42 | Re: Retrieving query results |