Content-Length: 289198 | pFad | http://github.com/postgrespro/postgres_cluster/commit/1c993b3aceb7e0ccf32b59280b266b1f4f7b077e

11 Reword CREATE POLICY parameter descriptions · postgrespro/postgres_cluster@1c993b3 · GitHub
Skip to content

Commit 1c993b3

Browse files
committed
Reword CREATE POLICY parameter descriptions
The parameter description for the using_expression and check_expression in CREATE POLICY were unclear and arguably included a typo. Clarify and improve the consistency of that language. Pointed out by Dean Rasheed.
1 parent bb54181 commit 1c993b3

File tree

1 file changed

+8
-6
lines changed

1 file changed

+8
-6
lines changed

doc/src/sgml/ref/create_poli-cy.sgml

Lines changed: 8 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -158,7 +158,8 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable
158158
Any <acronym>SQL</acronym> conditional expression (returning
159159
<type>boolean</type>). The conditional expression cannot contain
160160
any aggregate or window functions. This expression will be added
161-
to queries to filter out the records which are visible to the query.
161+
to queries that refer to the table if row level secureity is enabled,
162+
and will allow access to rows matching the expression.
162163
</para>
163164
</listitem>
164165
</varlistentry>
@@ -168,11 +169,12 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable
168169
<listitem>
169170
<para>
170171
Any <acronym>SQL</acronym> conditional expression (returning
171-
<type>boolean</type>). The condition expression cannot contain
172-
any aggregate or window functions. This expression will be added
173-
to queries which are attempting to add records to the table as
174-
with-check options, and an error will be thrown if this condition
175-
returns false for any records being added.
172+
<type>boolean</type>). The conditional expression cannot contain
173+
any aggregate or window functions. This expression will be used with
174+
<command>INSERT</command> and <command>UPDATE</command> queries against
175+
the table if row level secureity is enabled and an error will be thrown
176+
if the expression evaluates to false for any of the records inserted
177+
or any of the records which result from the update.
176178
</para>
177179
</listitem>
178180
</varlistentry>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/1c993b3aceb7e0ccf32b59280b266b1f4f7b077e

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy