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-000AEH-05@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
------
REL_18_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/dfc15bd3286dc7828c7666bfca06c76252305517

Modified Files
--------------
doc/src/sgml/ref/create_policy.sgml | 10 ++++++++--
1 file changed, 8 insertions(+), 2 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