Re: pqgetresultset problem

On Thu, 14 Aug 2003, P.Harikrishnan wrote:

> Hi Stephan,
>  Thanx for the reply.
>   I am using asynchronous execution of queries and not pqexec.
>   So it is possible to get all the result sets one by one by calling
> pqGetResultset till it returns NULL
>   So I am assuming that i can leave the query which failed and process the
> rest of the resultsets. But what is happening is once a
>   query fails, pqGetResultset return NULL.

My guess would be that the queries are probably still sent as a single
transaction given that PQexec appears to basically be: setup, use
PQsendQuery, get the result from the last result. The following queries
fail because you can't do queries while in the failed transaction state.