v2-0001-PGDOCS-replica-identity-quotes.patch
application/octet-stream
Filename: v2-0001-PGDOCS-replica-identity-quotes.patch
Type: application/octet-stream
Part: 0
Message:
Re: PGDOCS - Replica Identity quotes
Patch
Format: format-patch
Series: patch v2-0001
Subject: PGDOCS - replica identity quotes
| File | + | − |
|---|---|---|
| doc/src/sgml/logical-replication.sgml | 5 | 5 |
From f32dd6636de7eb6faf16613f9fe881660ec9094a Mon Sep 17 00:00:00 2001
From: Peter Smith <peter.b.smith@fujitsu.com>
Date: Fri, 17 Mar 2023 10:43:01 +1100
Subject: [PATCH v2] PGDOCS - replica identity quotes
---
doc/src/sgml/logical-replication.sgml | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml
index 6b0e300..967c311 100644
--- a/doc/src/sgml/logical-replication.sgml
+++ b/doc/src/sgml/logical-replication.sgml
@@ -124,24 +124,24 @@
</para>
<para>
- A published table must have a <quote>replica identity</quote> configured in
+ A published table must have a <firstterm>replica identity</firstterm> configured in
order to be able to replicate <command>UPDATE</command>
and <command>DELETE</command> operations, so that appropriate rows to
update or delete can be identified on the subscriber side. By default,
this is the primary key, if there is one. Another unique index (with
certain additional requirements) can also be set to be the replica
identity. If the table does not have any suitable key, then it can be set
- to replica identity <quote>full</quote>, which means the entire row becomes
- the key. When replica identity <quote>full</quote> is specified,
+ to <literal>REPLICA IDENTITY FULL</literal>, which means the entire row becomes
+ the key. When <literal>REPLICA IDENTITY FULL</literal> is specified,
indexes can be used on the subscriber side for searching the rows. Candidate
indexes must be btree, non-partial, and have at least one column reference
(i.e. cannot consist of only expressions). These restrictions
on the non-unique index properties adhere to some of the restrictions that
are enforced for primary keys. If there are no such suitable indexes,
the search on the subscriber side can be very inefficient, therefore
- replica identity <quote>full</quote> should only be used as a
+ <literal>REPLICA IDENTITY FULL</literal> should only be used as a
fallback if no other solution is possible. If a replica identity other
- than <quote>full</quote> is set on the publisher side, a replica identity
+ than <literal>FULL</literal> is set on the publisher side, a replica identity
comprising the same or fewer columns must also be set on the subscriber
side. See <xref linkend="sql-altertable-replica-identity"/> for details on
how to set the replica identity. If a table without a replica identity is
--
1.8.3.1