pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. - Mailing list pgsql-committers

From Dean Rasheed
Subject pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING.
Date
Msg-id E1vq7Rf-000AEF-00@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING.

On the CREATE POLICY page, the description of per-command policies
stated that SELECT policies are applied when an INSERT has an ON
CONFLICT DO NOTHING clause. However, that is only the case if it
includes an arbiter clause, so clarify that.

While at it, also clarify the comment in the regression tests that
cover this.

Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Reviewed-by: Viktor Holmberg <v@viktorh.net>
Discussion: https://postgr.es/m/CAEZATCXGwMQ+x00YY9XYG46T0kCajH=21QaYL9Xatz0dLKii+g@mail.gmail.com
Backpatch-through: 14

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/227a6ea65740bb8c5b1f37df016d7861fcba11c5

Modified Files
--------------
doc/src/sgml/ref/create_policy.sgml       | 10 ++++++++--
src/test/regress/expected/rowsecurity.out |  5 +++--
src/test/regress/sql/rowsecurity.sql      |  5 +++--
3 files changed, 14 insertions(+), 6 deletions(-)


pgsql-committers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: pgsql: Remove useless store to local variable
Next
From: Dean Rasheed
Date:
Subject: pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON