| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | "P(dot)Harikrishnan" <harikrishnan(at)midascomm(dot)com> |
| Cc: | Postgresql Novice List <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: pqgetresultset problem |
| Date: | 2003-08-14 12:07:18 |
| Message-ID: | 20030814050242.O80590-100000@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Hihn | 2003-08-14 13:12:20 | User/login questions |
| Previous Message | Nabil Sayegh | 2003-08-14 10:21:57 | Re: drop/add fk in transaction |