Content-Type: text/plain; charset="iso-8859-15"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Subject: Re: Pipeline Mode vs Single Row Mode / Chunked Rows Mode
From: "Daniel Verite" <daniel@manitou-mail.org>
To: "Daniel Frey" <d.frey@gmx.de>
Cc: "pgsql-general" <pgsql-general@lists.postgresql.org>
In-Reply-To: <A86C45C5-4E99-49B8-93E0-EEDC3DA4235B@gmx.de>
Date: Mon, 06 Jan 2025 20:47:38 +0100
Message-Id: <68c8b6c6-ae2e-4875-a08e-e6a26a04678e@manitou-mail.org>
Archived-At: <https://www.postgresql.org/message-id/68c8b6c6-ae2e-4875-a08e-e6a26a04678e%40manitou-mail.org>
Precedence: bulk

	Daniel Frey wrote:

> I tried to understand the interaction between Pipeline Mode and
> Single Row Mode / Chunked Rows Mode. It seems that it works
> sometimes, but I don't get the feeling that it was deliberately
> designed to work consistently

It's supposed to work, and there are regression tests in
src/test/modules/libpq_pipeline/libpq_pipeline.c [1]
that exercise the single row mode and PQpipelineSync().

You might want to compare your code workflow with how it's done in
that file, and maybe submit a bug report with your test case if the
conclusion is that your code should not error out.


[1]
https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dblob;f=3Dsrc/test=
/modules/libpq_pipeline/libpq_pipeline.c

Best regards,
--=20
Daniel V=E9rit=E9
https://postgresql.verite.pro/
Twitter: @DanielVerite