From 2498d8296eebd6706d5a00886a4f5ba02a1fe261 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 15 Aug 2005 02:40:36 +0000 Subject: Clean up some stray remaining references to pg_shadow, pg_user, pg_group. --- doc/src/sgml/ref/dropuser.sgml | 49 +++++++++++++++++++++--------------------- doc/src/sgml/ref/reindex.sgml | 9 ++++---- doc/src/sgml/xaggr.sgml | 18 ++++++++-------- 3 files changed, 38 insertions(+), 38 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/dropuser.sgml b/doc/src/sgml/ref/dropuser.sgml index ee38f0facb3..66d38d1ec13 100644 --- a/doc/src/sgml/ref/dropuser.sgml +++ b/doc/src/sgml/ref/dropuser.sgml @@ -1,5 +1,5 @@ @@ -33,17 +33,16 @@ PostgreSQL documentation dropuser removes an existing - PostgreSQL user - and the databases which that user owned. - Only superusers (users with usesuper set in - the pg_shadow table) can destroy - PostgreSQL users. + PostgreSQL user. + Only superusers and users with the CREATEROLE privilege can + remove PostgreSQL users. (To remove a + superuser, you must yourself be a superuser.) dropuser is a wrapper around the - SQL command . + SQL command . There is no effective difference between dropping users via this utility and via other methods for accessing the server. @@ -62,8 +61,8 @@ PostgreSQL documentation username - Specifies the name of the PostgreSQL user to be removed. - You will be prompted for a name if none is specified on the command line. + Specifies the name of the PostgreSQL user to be removed. + You will be prompted for a name if none is specified on the command line. @@ -74,7 +73,7 @@ PostgreSQL documentation Echo the commands that dropuser generates - and sends to the server. + and sends to the server. @@ -111,10 +110,10 @@ PostgreSQL documentation - Specifies the host name of the machine on which the - server - is running. If the value begins with a slash, it is used - as the directory for the Unix domain socket. + Specifies the host name of the machine on which the + server + is running. If the value begins with a slash, it is used + as the directory for the Unix domain socket. @@ -124,9 +123,9 @@ PostgreSQL documentation - Specifies the TCP port or local Unix domain socket file - extension on which the server - is listening for connections. + Specifies the TCP port or local Unix domain socket file + extension on which the server + is listening for connections. @@ -179,8 +178,8 @@ PostgreSQL documentation Diagnostics - In case of difficulty, see and for + In case of difficulty, see and for discussions of potential problems and error messages. The database server must be running at the targeted host. Also, any default connection settings and environment @@ -199,7 +198,7 @@ PostgreSQL documentation server: $ dropuser joe -DROP USER +DROP ROLE @@ -209,10 +208,10 @@ PostgreSQL documentation command: $ dropuser -p 5000 -h eden -i -e joe -User "joe" and any owned databases will be permanently deleted. +Role "joe" will be permanently removed. Are you sure? (y/n) y -DROP USER "joe" -DROP USER +DROP ROLE "joe" +DROP ROLE @@ -223,7 +222,7 @@ DROP USER - + Environment Variables () diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index 4bb6b9ff756..012e89c8728 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -1,5 +1,5 @@ @@ -176,9 +176,10 @@ REINDEX { INDEX | TABLE | DATABASE | SYSTEM } nam If corruption is suspected in the indexes of any of the shared - system catalogs (pg_database, - pg_group, - pg_shadow, or + system catalogs (pg_authid, + pg_auth_members, + pg_database, + pg_shdepend, or pg_tablespace), then a standalone server must be used to repair it. REINDEX will not process shared catalogs in multiuser mode. diff --git a/doc/src/sgml/xaggr.sgml b/doc/src/sgml/xaggr.sgml index b4d96d575ce..84ef58fbe95 100644 --- a/doc/src/sgml/xaggr.sgml +++ b/doc/src/sgml/xaggr.sgml @@ -1,5 +1,5 @@ @@ -141,22 +141,22 @@ CREATE AGGREGATE array_accum ( SELECT attrelid::regclass, array_accum(attname) FROM pg_attribute - WHERE attnum > 0 AND attrelid = 'pg_user'::regclass + WHERE attnum > 0 AND attrelid = 'pg_tablespace'::regclass GROUP BY attrelid; - attrelid | array_accum -----------+----------------------------------------------------------------------------- - pg_user | {usename,usesysid,usecreatedb,usesuper,usecatupd,passwd,valuntil,useconfig} + attrelid | array_accum +---------------+--------------------------------------- + pg_tablespace | {spcname,spcowner,spclocation,spcacl} (1 row) SELECT attrelid::regclass, array_accum(atttypid) FROM pg_attribute - WHERE attnum > 0 AND attrelid = 'pg_user'::regclass + WHERE attnum > 0 AND attrelid = 'pg_tablespace'::regclass GROUP BY attrelid; - attrelid | array_accum -----------+------------------------------ - pg_user | {19,23,16,16,16,25,702,1009} + attrelid | array_accum +---------------+----------------- + pg_tablespace | {19,26,25,1034} (1 row) -- cgit v1.2.3