Re: Add Pipelining support in psql

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

To: "a.kozhemyakin" <a.kozhemyakin@postgrespro.ru>

Cc: Daniel Verite <daniel@manitou-mail.org>, Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>, Jelte Fennema-Nio <postgres@jeltef.nl>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2025-04-16T16:18:01Z

Lists: pgsql-hackers

On Wed, Apr 16, 2025 at 09:31:59PM +0700, a.kozhemyakin wrote:
> After commit 2cce0fe on master
> 
> ERROR:  unexpected message type 0x50 during COPY from stdin
> CONTEXT:  COPY psql_pipeline, line 1
> Pipeline aborted, command did not run
> psql: common.c:1510: discardAbortedPipelineResults: Assertion `res == ((void
> *)0) || result_status == PGRES_PIPELINE_ABORTED' failed.
> Aborted (core dumped)

Reproduced here, thanks for the report.  I'll look at that at the
beginning of next week, adding an open item for now.
--
Michael

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

psql: Fix assertion failures with pipeline mode
- 3631612eae9c 18.0 landed
psql: Rework TAP routine psql_fails_like() to define WAL sender context
- 0ff95e0a5be1 18.0 landed
psql: Split extended query protocol meta-commands in --help=commands
- 78231baaf967 18.0 landed
psql: Improve descriptions of \\flush[request] in --help
- 5743d122fcf3 18.0 landed
psql: Fix incorrect status code returned by \getresults
- 5ee7bd944ee8 18.0 landed
psql: Allow queries terminated by semicolons while in pipeline mode
- 2cce0fe440fb 18.0 landed
psql: Add \sendpipeline to send query buffers while in a pipeline
- 17caf6644546 18.0 landed
psql: Fix memory leak with \gx used within a pipeline
- 54d23601b978 18.0 landed
psql: Add pipeline status to prompt and some state variables
- 3ce357584e79 18.0 landed
Add more tests for utility commands in pipelines
- a4e986ef5a46 18.0 landed
psql: Add support for pipelines
- 41625ab8ea3d 18.0 landed
Add braces for if block with large comment in psql's common.c
- 40af897eb777 18.0 landed