Обсуждение: libpq: how to retrieve query result?

I retrieve asynchronous queries results using PQgetResult() which returns NULL not in case of some error, but when results end - so there is no way to know if database responded successfully or there happened some error?
For example, error can happen when column names are miswritten.

On 01/17/2011 09:00 PM, Вячеслав Блинников wrote:

I retrieve asynchronous queries results using PQgetResult() which returns NULL not in case of some error, but when results end - so there is no way to know if database responded successfully or there happened some error?
For example, error can happen when column names are miswritten.

I'm no authority on this but my understanding is that it if PQsendQuery returns "OK" the query was successful (for some definition of "successful").

/Fredric

Hey

Use PQresultStatus. See also PQresultErrorField.


--
// Dmitriy.

=?KOI8-R?B?99HexdPMwdcg4szJzs7Jy8/X?= <slavmfm@gmail.com> writes:
> I retrieve asynchronous queries results using PQgetResult() which returns
> NULL not in case of some error, but when results end - so there is no way to
> know if database responded successfully or there happened some error?
> For example, error can happen when column names are miswritten.

Huh?  You'll get back a PGresult with error status if the query failed.
NULL implies that you already collected the PGresult and there's nothing
more to do.

            regards, tom lane