Horton

doc: Mention all SELECT privileges required by INSERT ... ON CONFLICT.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: 51a0d766b34f1001daf3789cf2f6d1f991088394
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2026-02-11T10:53:00Z
Releases: 16.13 
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

Files

PathChange+/−
doc/src/sgml/ref/insert.sgml modified +7 −4

Documentation touched

Discussion