public inbox for [email protected]help / color / mirror / Atom feed
pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. 6+ messages / 1 participants [nested] [flat]
* pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. @ 2026-02-11 10:27 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:27 UTC (permalink / raw) To: [email protected] 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=21QaYL9Xatz0dLKii+g@mail.gmail.com Backpatch-through: 14 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/301449686df7e84699b6cab0afb8ab3119ddcd1f Modified Files -------------- doc/src/sgml/ref/create_policy.sgml | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. @ 2026-02-11 10:27 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:27 UTC (permalink / raw) To: [email protected] 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=21QaYL9Xatz0dLKii+g@mail.gmail.com Backpatch-through: 14 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/24dc2f3cd90b3f028fe6db2ba16c2d59e1dfbda6 Modified Files -------------- doc/src/sgml/ref/create_policy.sgml | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. @ 2026-02-11 10:27 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:27 UTC (permalink / raw) To: [email protected] 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=21QaYL9Xatz0dLKii+g@mail.gmail.com Backpatch-through: 14 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/1d8549e22a76612f0a8aa12dcd2b5a101fcd335c Modified Files -------------- doc/src/sgml/ref/create_policy.sgml | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. @ 2026-02-11 10:27 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:27 UTC (permalink / raw) To: [email protected] 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=21QaYL9Xatz0dLKii+g@mail.gmail.com Backpatch-through: 14 Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/e323c8d320d2d603d146383832229615145299b1 Modified Files -------------- doc/src/sgml/ref/create_policy.sgml | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. @ 2026-02-11 10:27 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:27 UTC (permalink / raw) To: [email protected] 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=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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. @ 2026-02-11 10:27 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:27 UTC (permalink / raw) To: [email protected] 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=21QaYL9Xatz0dLKii+g@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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2026-02-11 10:27 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-02-11 10:27 pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. Dean Rasheed <[email protected]> 2026-02-11 10:27 pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. Dean Rasheed <[email protected]> 2026-02-11 10:27 pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. Dean Rasheed <[email protected]> 2026-02-11 10:27 pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. Dean Rasheed <[email protected]> 2026-02-11 10:27 pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. Dean Rasheed <[email protected]> 2026-02-11 10:27 pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING. Dean Rasheed <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox