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 <[email protected]>
Reviewed-by: Viktor Holmberg <[email protected]>
Discussion: 
https://postgr.es/m/CAEZATCXGwMQ+x00YY9XYG46T0kCajH=21qayl9xatz0dlki...@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(-)

Reply via email to