On Thu, May 9, 2024 at 11:12 PM Bruce Momjian <br...@momjian.us> wrote: > > On Thu, May 9, 2024 at 07:49:55PM +0800, jian he wrote: > > On Thu, May 9, 2024 at 6:53 PM jian he <jian.universal...@gmail.com> wrote: > > > > > > On Thu, May 9, 2024 at 12:04 PM Bruce Momjian <br...@momjian.us> wrote: > > > > I have committed the first draft of the PG 17 release notes; you can > > > > see the results here: > > > > > > > > https://momjian.us/pgsql_docs/release-17.html > >
E.1.3.1.5. Privileges Add per-table GRANT permission MAINTAIN to control maintenance operations (Nathan Bossart) The operations are VACUUM, ANALYZE, REINDEX, REFRESH MATERIALIZE VIEW, CLUSTER, and LOCK TABLE. Add user-grantable role pg_maintain to control maintenance operations (Nathan Bossart) The operations are VACUUM, ANALYZE, REINDEX, REFRESH MATERIALIZE VIEW, CLUSTER, and LOCK TABLE. Allow roles with pg_monitor privileges to execute pg_current_logfile() (Pavlo Golub, Nathan Bossart) --------------- should be "REFRESH MATERIALIZED VIEW"? also "Allow roles with pg_monitor privileges to execute pg_current_logfile() (Pavlo Golub, Nathan Bossart)" "pg_monitor" is a predefined role, so technically, "with pg_monitor privileges" is not correct? -------------------------------------------------------------------------- Add function XMLText() to convert text to a single XML text node (Jim Jones) XMLText() should be xmltext() -------------------------------------------------------------------------- Add function to_regtypemod() to return the typemod of a string (David Wheeler, Erik Wienhold) I think this description does not mean the same thing as the doc[1] [1] https://www.postgresql.org/docs/devel/functions-info.html#FUNCTIONS-INFO-CATALOG -------------------------------------------------------------------------- Allow GROUP BY columns to be internally ordered to match ORDER BY (Andrei Lepikhov, Teodor Sigaev) This can be disabled using server variable enable_group_by_reordering. Probably `This can be disabled by setting the server variable enable_group_by_reordering to false`.