From b9a7a822723aebb16cbe7e5fb874e5124745b07e Mon Sep 17 00:00:00 2001 From: Alexander Korotkov Date: Wed, 17 May 2023 20:06:50 +0300 Subject: Revert "Add USER SET parameter values for pg_db_role_setting" This reverts commit 096dd80f3ccc and its fixups beecbe8e5001, afdd9f7f0e00, 529da086ba, db93e739ac61. Catversion is bumped. Discussion: https://postgr.es/m/d46f9265-ff3c-6743-2278-6772598233c2%40pgmasters.net --- doc/src/sgml/catalogs.sgml | 10 ---------- doc/src/sgml/ref/alter_database.sgml | 15 +-------------- doc/src/sgml/ref/alter_role.sgml | 22 +--------------------- doc/src/sgml/ref/alter_user.sgml | 2 +- doc/src/sgml/ref/psql-ref.sgml | 7 ------- 5 files changed, 3 insertions(+), 53 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 52408405521..ed32ca03495 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -3212,16 +3212,6 @@ SCRAM-SHA-256$<iteration count>:&l Defaults for run-time configuration variables - - - - setuser bool[] - - - Values of USER SET - flag for every setting in setconfig - - diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml index 5144e1f4ea4..2479c41e8d6 100644 --- a/doc/src/sgml/ref/alter_database.sgml +++ b/doc/src/sgml/ref/alter_database.sgml @@ -37,7 +37,7 @@ ALTER DATABASE name SET TABLESPACE ALTER DATABASE name REFRESH COLLATION VERSION -ALTER DATABASE name SET configuration_parameter { TO | = } { value | value USER SET | DEFAULT } +ALTER DATABASE name SET configuration_parameter { TO | = } { value | DEFAULT } ALTER DATABASE name SET configuration_parameter FROM CURRENT ALTER DATABASE name RESET configuration_parameter ALTER DATABASE name RESET ALL @@ -206,19 +206,6 @@ ALTER DATABASE name RESET ALL - - - USER SET - - - Specifies that the variable should be set on behalf of an ordinary role. - That allows non-superuser and non-replication roles to set placeholder - variables, whose permission requirements are not known yet; - see . The variable won't - be set if it appears to require superuser privileges. - - - diff --git a/doc/src/sgml/ref/alter_role.sgml b/doc/src/sgml/ref/alter_role.sgml index ff2b88e9b60..ab1ee45d54e 100644 --- a/doc/src/sgml/ref/alter_role.sgml +++ b/doc/src/sgml/ref/alter_role.sgml @@ -38,7 +38,7 @@ ALTER ROLE role_specification [ WIT ALTER ROLE name RENAME TO new_name -ALTER ROLE { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | value USER SET | DEFAULT } +ALTER ROLE { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT } ALTER ROLE { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT ALTER ROLE { role_specification | ALL } [ IN DATABASE database_name ] RESET configuration_parameter ALTER ROLE { role_specification | ALL } [ IN DATABASE database_name ] RESET ALL @@ -239,19 +239,6 @@ ALTER ROLE { role_specification | A - - - USER SET - - - Specifies that the variable should be set on behalf of an ordinary role. - That allows non-superuser and non-replication roles to set placeholder - variables, whose permission requirements are not known yet; - see . The variable won't - be set if it appears to require superuser privileges. - - - @@ -347,13 +334,6 @@ ALTER ROLE worker_bee SET maintenance_work_mem = 100000; ALTER ROLE fred IN DATABASE devel SET client_min_messages = DEBUG; - - - - Give a role a non-default placeholder setting on behalf of ordinary user: - - -ALTER ROLE fred SET my.param = 'value' USER SET; diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml index 24f737d5870..0ee89f54c5c 100644 --- a/doc/src/sgml/ref/alter_user.sgml +++ b/doc/src/sgml/ref/alter_user.sgml @@ -38,7 +38,7 @@ ALTER USER role_specification [ WIT ALTER USER name RENAME TO new_name -ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | value USER SET | DEFAULT } +ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT } ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] RESET configuration_parameter ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] RESET ALL diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index de760f99909..880d3d0b324 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1902,13 +1902,6 @@ INSERT INTO tbl1 VALUES ($1, $2) \bind 'first value' 'second value' \g commands are used to define per-role and per-database configuration settings. - - - Since PostgreSQL 16, the output includes a - column with the values of the - USER SET - flag for each setting. - -- cgit v1.2.3