Horton

Re: Regression in pipeline mode in libpq 14.5

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Cc: pgsql-bugs <pgsql-bugs@postgresql.org>
Date: 2022-08-15T15:24:37Z
Lists: pgsql-bugs 
On 2022-Aug-14, Daniele Varrazzo wrote:

> The execute() runs an implicit BEGIN, which is also executed in
> pipeline mode. Exiting the pipeline() block causes a Sync. So we
> expect 3 results in the pipeline (a COMMAND_OK after BEGIN, a
> TUPLES_OK after SELECT, a PIPELINE_SYNC).

Hmm, it seems (judging only from comparing your two traces) that the
problem stems from the newly added hack to handle CloseComplete.  I'll
have a look later in the week.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"No hay ausente sin culpa ni presente sin disculpa" (Prov. francés)

Commits

  1. Remove PQsendQuery support in pipeline mode

  2. Stop using PQsendQuery in libpq_pipeline