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-000AEK-07@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_17_STABLE

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

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