pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON - Mailing list pgsql-committers

From Dean Rasheed
Subject pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON
Date
Msg-id E1vq7td-000AaT-0p@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/cfd790159d5e2301b3534c8d63d75e904d050f6b

Modified Files
--------------
doc/src/sgml/ref/insert.sgml | 11 +++++++----
1 file changed, 7 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Dean Rasheed
Date:
Subject: pgsql: doc: Clarify RLS policies applied for ON CONFLICT DO NOTHING.
Next
From: Heikki Linnakangas
Date:
Subject: pgsql: Move ProcStructLock to the ProcGlobal struct