Skip to content

Commit ce6513e

Browse files
author
Amit Kapila
committed
Doc: Fix logical replication examples.
The definition of \dRp+ was modified in commit 7054186. This patch updates the column list and row filter examples to align with the revised definition. Author: Shlok Kyal <shlok.kyal.oss@gmail.com> Reviewed by: Peter Smith <smithpb2250@gmail.com> Backpatch-through: 18, where it was introduced Discussion: https://postgr.es/m/CANhcyEUvqkSO6b9zi_fs_BBPEge5acj4mf8QKmq2TX-7axa7EQ@mail.gmail.com
1 parent 19179db commit ce6513e

File tree

1 file changed

+21
-21
lines changed

1 file changed

+21
-21
lines changed

doc/src/sgml/logical-replication.sgml

Lines changed: 21 additions & 21 deletions
Original file line numberDiff line numberDiff line change
@@ -1048,28 +1048,28 @@ HINT: To initiate replication, you must manually create the replication slot, e
10481048
defined) for each publication.
10491049
<programlisting><![CDATA[
10501050
/* pub # */ \dRp+
1051-
Publication p1
1052-
Owner | All tables | Inserts | Updates | Deletes | Truncates | Via root
1053-
----------+------------+---------+---------+---------+-----------+----------
1054-
postgres | f | t | t | t | t | f
1051+
Publication p1
1052+
Owner | All tables | Inserts | Updates | Deletes | Truncates | Generated columns | Via root
1053+
----------+------------+---------+---------+---------+-----------+-------------------+----------
1054+
postgres | f | t | t | t | t | none | f
10551055
Tables:
1056-
"public.t1" WHERE ((a > 5) AND (c = 'NSW'::text))
1056+
"public.t1" WHERE ((a > 5) AND (c = 'NSW'::text))
10571057

1058-
Publication p2
1059-
Owner | All tables | Inserts | Updates | Deletes | Truncates | Via root
1060-
----------+------------+---------+---------+---------+-----------+----------
1061-
postgres | f | t | t | t | t | f
1058+
Publication p2
1059+
Owner | All tables | Inserts | Updates | Deletes | Truncates | Generated columns | Via root
1060+
----------+------------+---------+---------+---------+-----------+-------------------+----------
1061+
postgres | f | t | t | t | t | none | f
10621062
Tables:
1063-
"public.t1"
1064-
"public.t2" WHERE (e = 99)
1063+
"public.t1"
1064+
"public.t2" WHERE (e = 99)
10651065

1066-
Publication p3
1067-
Owner | All tables | Inserts | Updates | Deletes | Truncates | Via root
1068-
----------+------------+---------+---------+---------+-----------+----------
1069-
postgres | f | t | t | t | t | f
1066+
Publication p3
1067+
Owner | All tables | Inserts | Updates | Deletes | Truncates | Generated columns | Via root
1068+
----------+------------+---------+---------+---------+-----------+-------------------+----------
1069+
postgres | f | t | t | t | t | none | f
10701070
Tables:
1071-
"public.t2" WHERE (d = 10)
1072-
"public.t3" WHERE (g = 10)
1071+
"public.t2" WHERE (d = 10)
1072+
"public.t3" WHERE (g = 10)
10731073
]]></programlisting></para>
10741074

10751075
<para>
@@ -1491,10 +1491,10 @@ Publications:
14911491
for each publication.
14921492
<programlisting>
14931493
/* pub # */ \dRp+
1494-
Publication p1
1495-
Owner | All tables | Inserts | Updates | Deletes | Truncates | Via root
1496-
----------+------------+---------+---------+---------+-----------+----------
1497-
postgres | f | t | t | t | t | f
1494+
Publication p1
1495+
Owner | All tables | Inserts | Updates | Deletes | Truncates | Generated columns | Via root
1496+
----------+------------+---------+---------+---------+-----------+-------------------+----------
1497+
postgres | f | t | t | t | t | none | f
14981498
Tables:
14991499
"public.t1" (id, a, b, d)
15001500
</programlisting></para>

0 commit comments

Comments
 (0)