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