From 40023992dd73edaf7947796e0e4e36065fcd908c Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Wed, 23 Jun 2021 12:40:15 -0400 Subject: [PATCH v2 1/4] Clarify that pipeline sync is mandatory --- doc/src/sgml/libpq.sgml | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml index 641970f2a6..7f8a4db089 100644 --- a/doc/src/sgml/libpq.sgml +++ b/doc/src/sgml/libpq.sgml @@ -5102,10 +5102,12 @@ int PQflush(PGconn *conn); The server executes statements, and returns results, in the order the client sends them. The server will begin executing the commands in the pipeline immediately, not waiting for the end of the pipeline. + Do note that results are buffered on the server side; a synchronization + point, established with PQpipelineSync, is necessary + in order for all results to be flushed to the client. If any statement encounters an error, the server aborts the current transaction and does not execute any subsequent command in the queue - until the next synchronization point established by - PQpipelineSync; + until the next synchronization point; a PGRES_PIPELINE_ABORTED result is produced for each such command. (This remains true even if the commands in the pipeline would rollback -- 2.30.2