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-00639d-Cd@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
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/4bc8f29088f8a2e9c89e6c0819337c4c8bf5f20a

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().