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."