Re: assembling PGresults from multiple simultaneous queries (libpq, singlerowmode) - Mailing list pgsql-general

From Pavel Stehule
Subject Re: assembling PGresults from multiple simultaneous queries (libpq, singlerowmode)
Date
Msg-id CAFj8pRATA2yYv7rN3E86rJ9h7QLhskTbOmNi-f6qQ47wMvzieg@mail.gmail.com
Whole thread Raw
In response to assembling PGresults from multiple simultaneous queries (libpq, singlerowmode)  (Konstantin Izmailov <pgfizm@gmail.com>)
Responses Re: assembling PGresults from multiple simultaneous queries (libpq,singlerowmode)  (Andres Freund <andres@anarazel.de>)
List pgsql-general
Hi

ne 7. 4. 2019 v 20:47 odesílatel Konstantin Izmailov <pgfizm@gmail.com> napsal:
Hi,
I'm experimenting with Postgres 10 and protocol v3. I noticed that the Postgres allows executing multiple queries simultaneously (I basically commented out a check that prevents sending another query in libpq while previous result(s) reading is not complete). Things appear like working, but I just wanted to ask if anyone else tried the same (logically separate results from multiple simultaneous queries)?


Postgres cannot to execute simultaneous queries in one session. So queries should be executed in serial form every time.

Regards

Pavel

 
Afaik libpq was not designed for that scenario, but it seems the Postgres server supports it. Any thought or information will be appreciated.

Thank you!
Konstantin

pgsql-general by date:

Previous
From: Konstantin Izmailov
Date:
Subject: assembling PGresults from multiple simultaneous queries (libpq, singlerowmode)
Next
From: senor
Date:
Subject: Re: pg_upgrade --jobs