pgsql: doc: improve description of privileges for MERGE and update glos - Mailing list pgsql-committers

From Dean Rasheed
Subject pgsql: doc: improve description of privileges for MERGE and update glos
Date
Msg-id E1r4KgF-00639e-D1@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
doc: improve description of privileges for MERGE and update glossary.

On the MERGE page, the description of the privileges required could be
taken to imply that the SELECT privilege is required on all columns of
the data source, whereas actually it is only required on the columns
referred to by conditions or expressions in the MERGE command. Re-word
it to make that a little clearer, and mention expressions as well as
conditions.

Also, add a glossary entry for MERGE, and nearby on the glossary page,
mention MERGE in the list of commands that cannot update a
materialized view.

Noted by Jian He. Patch by me, reviewed by Jian He.

Discussion: https://postgr.es/m/CACJufxHuSoRXKwr0MtSFLXuT2nFVWcVfEWhxg7qdP9h%2Bs3a%2BUw%40mail.gmail.com

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/3b6728910ace14c64ffa43b538a84508f4fe6408

Modified Files
--------------
doc/src/sgml/glossary.sgml  | 21 +++++++++++++++++++--
doc/src/sgml/ref/merge.sgml | 10 +++++-----
2 files changed, 24 insertions(+), 7 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: meson: Fix missing dependency from install-quiet to sepgsql.sql
Next
From: Dean Rasheed
Date:
Subject: pgsql: Guard against overflow in interval_mul() and interval_div().