doc: foreign servers with pushdown need matching collation

Reported-by: Pete Storer
Discussion: https://postgr.es/m/BL0PR05MB66283C57D72E321591AE4EB1F3CE9@BL0PR05MB6628.namprd05.prod.outlook.com

Backpatch-through: 11

diff --git a/doc/src/sgml/ref/create_server.sgml b/doc/src/sgml/ref/create_server.sgml
index af0a7a06fdcdfd6330238b1d01cdc909b164af94..05f4019453ba2d9ed07e31ef89cb6fd344e96697 100644 (file)
--- a/doc/src/sgml/ref/create_server.sgml
+++ b/doc/src/sgml/ref/create_server.sgml
@@ -129,6 +129,11 @@ CREATE SERVER [ IF NOT EXISTS ] <replaceable class="parameter">server_name</repl
    the <literal>USAGE</literal> privilege on the foreign server to be
    able to use it in this way.
   </para>
+
+  <para>
+   If the foreign server supports sort pushdown, it is necessary for it
+   to have the same sort ordering as the local server.
+  </para>
  </refsect1>
 
  <refsect1>