]> git.ipfire.org Git - thirdparty/postgresql.git/commit
doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Wed, 11 Feb 2026 10:25:06 +0000 (10:25 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Wed, 11 Feb 2026 10:25:06 +0000 (10:25 +0000)
commitdfc15bd3286dc7828c7666bfca06c76252305517
tree46b273d47cedca35665c67dc4eb0e6641fc01d3a
parent5a461dc4dbf72a1ec281394a76eb36d68cbdd935
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
doc/src/sgml/ref/create_policy.sgml