postgres.git / summary / log / commit / refs

commit    c829fbc3dc93d43bc499499164ac42c4edb1cb70
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Fri Nov 05 14:40:03 2021 +0000

    Pipeline mode disallows multicommand strings
    
    ... so mention that in appropriate places of the libpq docs.
    
    Backpatch to 14.
    
    Reported-by: RekGRpth <rekgrpth@gmail.com>
    Discussion: https://postgr.es/m/17235-53bb38fc5be593dc@postgresql.org


 doc/src/sgml/libpq.sgml | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml
index b449c834a95..c17d33a54f0 100644
--- a/doc/src/sgml/libpq.sgml
+++ b/doc/src/sgml/libpq.sgml
@@ -4594,6 +4594,11 @@ int PQsendQuery(PGconn *conn, const char *command);
        (on the same connection) until <xref linkend="libpq-PQgetResult"/>
        has returned a null pointer, indicating that the command is done.
       </para>
+
+      <para>
+       In pipeline mode, command strings containing more than one SQL command
+       are disallowed.
+      </para>
      </listitem>
     </varlistentry>
 
@@ -5046,7 +5051,8 @@ int PQflush(PGconn *conn);
     <xref linkend="libpq-PQpipelineStatus"/> can be used
     to test whether pipeline mode is active.
     In pipeline mode, only <link linkend="libpq-async">asynchronous operations</link>
-    are permitted, and <literal>COPY</literal> is disallowed.
+    are permitted, command strings containing multiple SQL commands are
+    disallowed, and so is <literal>COPY</literal>.
     Using synchronous command execution functions
     such as <function>PQfn</function>,
     <function>PQexec</function>,


[parent: f4e3b62710c0]