Re: libpq: how to get a sequence of partial PGresult-s - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: libpq: how to get a sequence of partial PGresult-s
Date
Msg-id 23995.1064356049@sss.pgh.pa.us
Whole thread Raw
In response to libpq: how to get a sequence of partial PGresult-s  (Igor Shevchenko <igor@carcass.ath.cx>)
Responses Re: libpq: how to get a sequence of partial PGresult-s  (Igor Shevchenko <igor@carcass.ath.cx>)
List pgsql-interfaces
Igor Shevchenko <igor@carcass.ath.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


pgsql-interfaces by date:

Previous
From: Igor Shevchenko
Date:
Subject: libpq: how to get a sequence of partial PGresult-s
Next
From: Igor Shevchenko
Date:
Subject: Re: libpq: how to get a sequence of partial PGresult-s