Re: PQgetResultSet Problem - Mailing list pgsql-general

From Tom Lane
Subject Re: PQgetResultSet Problem
Date
Msg-id 20346.1061270467@sss.pgh.pa.us
Whole thread Raw
In response to Re: PQgetResultSet Problem  (Deepa K <kdeepa@midascomm.com>)
List pgsql-general
Deepa K <kdeepa@midascomm.com> writes:
> 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.

psql splits your input at semicolons, and ships each command to the
backend in a separate PQexec.  You're wasting your time suggesting
that we should change this behavior in either PQexec or psql --- we'd
break far too many applications for far too little gain.

            regards, tom lane

pgsql-general by date:

Previous
From: Deepa K
Date:
Subject: Re: PQgetResultSet Problem
Next
From: Stephan Szabo
Date:
Subject: Re: Why lower's not accept an AS declaration ?