Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit1c993b3

Browse files
committed
Reword CREATE POLICY parameter descriptions
The parameter description for the using_expression and check_expressionin CREATE POLICY were unclear and arguably included a typo. Clarifyand improve the consistency of that language.Pointed out by Dean Rasheed.
1 parentbb54181 commit1c993b3

File tree

1 file changed

+8
-6
lines changed

1 file changed

+8
-6
lines changed

‎doc/src/sgml/ref/create_policy.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 security 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 security 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)
[8]ページ先頭
©2009-2025 Movatter.jp