Re: libpq: how to get a sequence of partial PGresult-s

Igor Shevchenko <igor(at)carcass(dot)ath(dot)cx> writes:
> Is there any way to get/process this partial PGresult in my
> app ? I haven't found any API function for this, so I thought about an
> additional function for the libpq's API -
> PGresult* PQgetNextResult ( PGconn* conn );

I think this is a really bad idea, because it destroys libpq's basic
concept that you get either success or failure for a command. Peeking
at a partially-arrived result might give you back some rows only to get
an error later (since the backend may fail partway through a query).

I'm not sure that the partially constructed result is valid anyway;
the last row may be in a funny state. And what happens if the
application does a PQclear() on it??

regards, tom lane