Igor Korot <ikorot01@gmail.com> writes:
> So there is no way to retrieve an arbitrary number of rows from the query?
> That sucks...
The restriction is on the number of rows in one PGresult, not the total
size of the query result. You could use single-row mode, or use a cursor
and fetch some reasonable number of rows at a time. If you try to inhale
all of a many-gigarow result at once, you're going to have OOM problems
anyway, even if you had the patience to wait for it. So I don't think the
existence of a limit is a problem. Failure to check it *is* a problem,
certainly.
regards, tom lane