publication_filtering_warning.diff
text/x-diff
Filename: publication_filtering_warning.diff
Type: text/x-diff
Part: 0
Message:
Re: Privileges on PUBLICATION
Patch
Format: unified
| File | + | − |
|---|---|---|
| doc/src/sgml/ref/create_publication.sgml | 10 | 0 |
diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml
index 1a828e8d2ff..b74ba625649 100644
--- a/doc/src/sgml/ref/create_publication.sgml
+++ b/doc/src/sgml/ref/create_publication.sgml
@@ -94,6 +94,16 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
list is specified, it must include the replica identity columns.
</para>
+ <warning>
+ <para>
+ If you are using the <literal>WHERE</literal> clause or the column list
+ to omit some table data from the replication for security reasons,
+ please make sure that the same data is not exposed via other
+ publications which contain the same table and have different (or
+ none) <literal>WHERE</literal> clause or column list.
+ </para>
+ </warning>
+
<para>
Only persistent base tables and partitioned tables can be part of a
publication. Temporary tables, unlogged tables, foreign tables,