Tom Lane wrote:
regression=# create rule r1 as on insert to surprise do regression-# ( select 'hello' ; select 'how are you' ); CREATE RULE
The 'hello' result was in fact computed and sent by the backend, but it was discarded in libpq (see the documentation about PQexec: only the last resultset returned by a querystring is returned to the caller). psql could have printed both results, but it would need to use PQsendQuery/PQgetResult instead of PQexec.
Yikes. I thought this couldn't happen under the V3 extended query protocol.
The JDBC driver currently sends Describe/Execute and expects exactly one of RowDescription/NoData followed by zero or more DataRows followed by one of CommandComplete/EmptyQueryResponse/PortalSuspended. This seems wrong if there could be multiple resultsets from a single Execute.
How can clients distinguish multiple resultsets if they're using the extended query protocol?
-O
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
