]> 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:53:01 +0000 (10:53 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Wed, 11 Feb 2026 10:53:01 +0000 (10:53 +0000)
commitcfd790159d5e2301b3534c8d63d75e904d050f6b
tree3b4b84367c0d9d6c06a0c58416d8b2ab9fdb4081
parent24dc2f3cd90b3f028fe6db2ba16c2d59e1dfbda6
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