Re: pqgetresultset problem

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.

Can anybody help me plz.

Stephan Szabo wrote:

> On Wed, 13 Aug 2003, P.Harikrishnan wrote:
>
> > Hi all,
> > I am using postgresql 7.1.3 and a client using libpq.
> > I am executing a statement with muliple SQL commands semicolon
> > seperated.
> > If any one of the query in between fails, pqGetResultset returns
> > NULL on the failed query. So i am unable to process the rest of the
> > queries.
> > Also the queries which were before the failed query, which were
> > successful, were also not commited to the database.
> >
> > (eg) query1;query2;query3;query4
> >
> > If query1 is successful and query2 fails, the pqGetResultset returns
> > NULL on query2. So my client comes out of while (pqGetResultSet). The
> > query1 which was successful was also not commited to the database.
> >
> > If i run the same from psql client, the query2 alone fails, the rest
> > other are inserted to the database.
>
> >From the current libpq docs:
>
> It is allowed to include multiple SQL commands (separated by semicolons)
> in the command string. Multiple queries sent in a single
> <function>PQexec</> call are processed in a single transaction, unless
> there are explicit BEGIN/COMMIT commands included in the query string to
> divide it into multiple transactions. Note however that the returned
> <structname>PGresult</structname> structure describes only the result of
> the last command executed from the string. Should one of the commands
> fail, processing of the string stops with it and the returned
> <structname>PGresult</structname> describes the error condition.
>
> I think psql separates the query at the semicolons before passing it to
> the database. If you want psql's behavior you should probably do the
> same.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Regards,
Hari