]> 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:10 +0000 (10:25 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Wed, 11 Feb 2026 10:25:10 +0000 (10:25 +0000)
commit301449686df7e84699b6cab0afb8ab3119ddcd1f
treef58c21ab80c76c5d4c84db076e7cc3a9d2b00463
parenteb788b43371849237c61ba2747fc11e96c08d861
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