pgsql: doc: improve description of privileges for MERGE and update glos

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: doc: improve description of privileges for MERGE and update glos
Date: 2023-11-18 12:44:11
Message-ID: E1r4KgF-00639h-DU@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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_15_STABLE

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

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

Browse pgsql-committers by date

  From Date Subject
Next Message Dean Rasheed 2023-11-18 14:52:45 pgsql: Guard against overflow in interval_mul() and interval_div().
Previous Message Andres Freund 2023-11-18 02:55:26 pgsql: meson: Fix missing dependency from install-quiet to sepgsql.sql