diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-11-05 11:40:03 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-11-05 11:40:03 -0300 |
| commit | 105c1de0197473dac8ada55dc8cf773d782224cb (patch) | |
| tree | ec504a79957698267b2bba560fc1861781541d1e | |
| parent | e543906e217509ad95c1e341de4e874f027f871b (diff) | |
| download | postgresql-105c1de0197473dac8ada55dc8cf773d782224cb.tar.gz postgresql-105c1de0197473dac8ada55dc8cf773d782224cb.zip | |
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
| -rw-r--r-- | doc/src/sgml/libpq.sgml | 8 |
1 files changed, 7 insertions, 1 deletions
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>, |