From: | Deepa K <kdeepa(at)midascomm(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PQgetResultSet Problem |
Date: | 2003-08-19 04:52:58 |
Message-ID: | 3F41AD2A.14046EC9@midascomm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-19 05:21:07 | Re: PQgetResultSet Problem |
Previous Message | Jamie Lawrence | 2003-08-19 04:37:50 | Re: Example Database |