]> git.ipfire.org Git - thirdparty/postgresql.git/commit
doc: Mention all SELECT privileges required by INSERT ... ON CONFLICT.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Wed, 11 Feb 2026 10:52:58 +0000 (10:52 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Wed, 11 Feb 2026 10:52:58 +0000 (10:52 +0000)
commitbc953bf52314ca881a18703f86b68743ef6f3a32
treef3ab243b5c9c6c0f06613263ce97c1f0286d02be
parent227a6ea65740bb8c5b1f37df016d7861fcba11c5
doc: Mention all SELECT privileges required by INSERT ... ON CONFLICT.

On the INSERT page, mention that SELECT privileges are also required
for any columns mentioned in the arbiter clause, including those
referred to by the constraint, and clarify that this applies to all
forms of ON CONFLICT, not just ON CONFLICT DO UPDATE.

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/insert.sgml