Thread: PQsendQueryParams() causes prepared statement error

in 9.2.0:

PQsendQueryParams() with multiple command statement (like "select 123;
select 456") unexpectedly causes error:

"cannot insert multiple commands into a prepared statement."

But PQsendQuery() works fine.

Denis Feklushkin <denis.feklushkin@gmail.com> writes:
> in 9.2.0:
> PQsendQueryParams() with multiple command statement (like "select 123;
> select 456") unexpectedly causes error:

> "cannot insert multiple commands into a prepared statement."

This is not a bug, it's intentional (and documented) behavior.

            regards, tom lane

В Срд, 07/11/2012 в 11:48 -0500, Tom Lane пишет:
> Denis Feklushkin <denis.feklushkin@gmail.com> writes:
> > in 9.2.0:
> > PQsendQueryParams() with multiple command statement (like "select 123;
> > select 456") unexpectedly causes error:
>
> > "cannot insert multiple commands into a prepared statement."
>
> This is not a bug, it's intentional (and documented) behavior.

Advise as I can override this? I am need a simple form of overlapped
processing, as in manual: "the client can be handling the results of one
command while the server is still working on later queries in the same
command string."