Re: [HACKERS] Revised proposal for libpq and FE/BE protocol changes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Revised proposal for libpq and FE/BE protocol changes
Date
Msg-id 8596.893860094@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Revised proposal for libpq and FE/BE protocol changes  (ocie@paracel.com)
Responses Re: [HACKERS] Revised proposal for libpq and FE/BE protocol changes
List pgsql-hackers
ocie@paracel.com writes:
> You didn't come right out and say it, but are you intending to support
> multiple queries within a connection?  I gather not.  Not that I'm
> suggesting that this be done, as it seems this would complicate the
> user's application and the backend.  With only one possible OOB
> message, you can't tell it which query to cancel.

That was something I asked about a few days ago, and didn't get any
responses suggesting that anyone thought it was likely to happen.

We would need wholesale changes everywhere in the protocol to support
concurrent queries: answers and errors coming back would have to be
tagged to indicate which query they apply to.  The lack of a tag in
the cancel message isn't the controlling factor.

In the current system architecture, much the easiest way to execute
concurrent queries is to open up more than one connection.  There's
nothing that says a frontend process can't fire up multiple backend
processes.  I think this is probably sufficient, because I don't
foresee such a thing becoming really popular anyway.

            regards, tom lane

pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [INTERFACES] Access'97 and ODBC
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Revised proposal for libpq and FE/BE protocol changes