Re: PQgetResultSet Problem

Thanks Tom.

But we run a set of commands in psql command line, if any one of query
fails, other commands gets executed. Why this is possible in psql and
not using application.

TIA
Deepa. K


Tom Lane wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend