| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Samuel Williams <space(dot)ship(dot)traveller(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: libpq pipelineing |
| Date: | 2020-06-27 04:15:49 |
| Message-ID: | CAKFQuwZtD7Ne6ANiOgCa40YhPBEhDcDMo8nK8TuR3LKUxbjnjA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Friday, June 26, 2020, Samuel Williams <space(dot)ship(dot)traveller(at)gmail(dot)com>
wrote:
> Hello,
>
> Using the asynchronous interface of libpq, is it possible to pipeline
> multiple queries?
>
> i.e.
>
> PQsendQuery(query1)
> PQsendQuery(query2)
>
> followed by
>
> query1_results = PQgetResult(...)
> query2_results = PQgetResult(...)
>
> I tried it but got "another command is already in progress" error.
>
The documentation seems to leave zero ambiguity:
After successfully calling PQsendQuery, call PQgetResult one or more times
to obtain the results. PQsendQuery cannot be called again (on the same
connection) until PQgetResult has returned a null pointer, indicating that
the command is done.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Samuel Williams | 2020-06-27 04:57:41 | Re: libpq pipelineing |
| Previous Message | Samuel Williams | 2020-06-27 03:57:01 | libpq pipelineing |