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