Deepa K <kdeepa(at)midascomm(dot)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