pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING.

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING.
Date: 2026-02-11 10:27:44
Message-ID: E1vq7Rf-000AEH-05@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(dot)a(dot)rasheed(at)gmail(dot)com>
Reviewed-by: Viktor Holmberg <v(at)viktorh(dot)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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Dean Rasheed 2026-02-11 10:56:38 pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON
Previous Message Heikki Linnakangas 2026-02-11 10:03:51 Re: PGPROC alignment (was Re: pgsql: Separate RecoveryConflictReasons from procsignals)