MIME-Version: 1.0
References: 
 <CAGECzQRe3pHYvEAZz5Nv9AKzS2nYFLKEfgQCgd5Gr54Um5UFHg@mail.gmail.com>
 <d8aa9cb9-2fa1-464e-b1f1-63a68924b95f@manitou-mail.org>
 <CAO6_Xqq4JEHRaGyC=r+dpi0Ejbp2P3aUo-KfR2NuipCvE-o_ZA@mail.gmail.com>
 <Z9jDU_v_eGbZNkCU@paquier.xyz>
 <CAO6_Xqo=fNh0KCRZG7T18OZfjiabeL-t4C6mkXsz-3dAZ1YwTA@mail.gmail.com>
In-Reply-To: 
 <CAO6_Xqo=fNh0KCRZG7T18OZfjiabeL-t4C6mkXsz-3dAZ1YwTA@mail.gmail.com>
From: Jelte Fennema-Nio <postgres@jeltef.nl>
Date: Tue, 18 Mar 2025 10:27:38 +0100
Message-ID: 
 <CAGECzQS=nVLg0VpPrWCQT3ANFhC6iR=p8Oe6edgqGDUUCGLiwg@mail.gmail.com>
Subject: Re: Add Pipelining support in psql
To: Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>
Cc: Michael Paquier <michael@paquier.xyz>,
 Daniel Verite <daniel@manitou-mail.org>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGECzQS%3DnVLg0VpPrWCQT3ANFhC6iR%3Dp8Oe6edgqGDUUCGLiwg%40mail.gmail.com>
Precedence: bulk

On Tue, 18 Mar 2025 at 09:55, Anthonin Bonnefoy
<anthonin.bonnefoy@datadoghq.com> wrote:
> I've added additional tests when piping queries with ';':
> - I've reused the same scenario with \sendpipeline: single query,
> multiple queries, flushes, syncs, using COPY...
> - Using ';' will replace the unnamed prepared statement. It's a bit
> different from expected as a simple query will delete the unnamed
> prepared statement.
> - Sending an extended query prepared with \bind using a ';' on a
> newline, though this is not specific to pipelining. The scanned
> semicolon triggers the call to SendQuery, processing the buffered
> extended query. It's a bit unusual but that's the current behaviour.

One thing that comes to mind that I think would be quite useful and
pretty easy to implement if we have this functionality within a
pipeline: An \extended command. That puts psql in "extended protocol
mode" (without enabling pipelining). In "extended protocol mode" all
queries would automatically be sent using PQsendQueryParams. That
would remove the need to use \bind anymore outside of a pipeline
either.