Horton
Menu

Re: BUG #18944: Assertion Failure in psql with idle_session_timeout Set

Michael Paquier <michael@paquier.xyz>

View thread
From: Michael Paquier <michael@paquier.xyz>
To: Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>
Cc: Никита Калинин <n.kalinin@postgrespro.ru>, pgsql-bugs@lists.postgresql.org
Date: 2025-06-12T08:03:27Z
Lists: pgsql-bugs 
On Thu, Jun 12, 2025 at 09:38:41AM +0200, Anthonin Bonnefoy wrote:
> The attached patch now aborts the connection anytime we enter COPY
> state while within a pipeline and removes all pipeline+COPY from the
> SQL tests.

Thanks for the patch, that's exactly what I was testing today, as a
simple way to handle the problem reported.  I'll check that in more
details tomorrow, running a bit out of time today..

Do you think that it is worth adding a sentence about this restriction
in the docs in the section dedicated to the pipeline meta-commands?
We could just add a simple sentence like "<command>COPY</command>
command is not supported while in pipeline mode."
--
Michael

Commits

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

  1. psql: Forbid use of COPY and \copy while in a pipeline

  2. psql: Abort connection when using \syncpipeline after COPY TO/FROM