Re: PQgetResultSet Problem

Deepa K <kdeepa@midascomm.com> writes:
>     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.

That's what it's supposed to do.

>    Also the queries which were before the failed query, which were
> successful, were also not commited to the database.

Likewise.

If this is not the behavior you want, then submit the commands
separately.

            regards, tom lane