pgsql: Doc: Fix pg_copy_logical_replication_slot description.

Doc: Fix pg_copy_logical_replication_slot description.

This commit documents that the failover option is not copied when using
the pg_copy_logical_replication_slot function.

In passing, we modify the comments in the function clarifying the reason
for this behavior.

Reported-by: <duffieldzane(at)gmail(dot)com>
Author: Hou Zhijie <houzj(dot)fnst(at)fujitsu(dot)com>
Reviewed-by: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Backpatch-through: 17, where it was introduced
Discussion: https://postgr.es/m/173976850802.682632.11315364077431550250@wrigleys.postgresql.org

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/7c906c5b46f8189a04e67bc550cba33dd3851b6e

Modified Files
--------------
doc/src/sgml/func.sgml | 4 ++++
src/backend/replication/slotfuncs.c | 19 ++++++++++++-------
2 files changed, 16 insertions(+), 7 deletions(-)