Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fskVZ-0003Dv-Im for pgsql-docs@arkaria.postgresql.org; Thu, 23 Aug 2018 07:58:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fskVW-0007Ai-6K for pgsql-docs@arkaria.postgresql.org; Thu, 23 Aug 2018 07:58:18 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fskVU-0007Ab-De for pgsql-docs@lists.postgresql.org; Thu, 23 Aug 2018 07:58:18 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fskVP-0000vZ-Lt for pgsql-docs@postgresql.org; Thu, 23 Aug 2018 07:58:15 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id D7C6920E73 for ; Thu, 23 Aug 2018 03:58:09 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Thu, 23 Aug 2018 03:58:09 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= content-type:date:from:message-id:mime-version:subject:to :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=QLv7UvOJ2eVWE+O8I gsNEqMHHTiRM7NYtdErP2qDfLs=; b=wA0C/xWEcU9jIyrzI3JOMiUJDxZi7qIAS NKhi3q8XXGFVba/qFLBak8L0/vq6CDH4IzLLjjTqsjpJoUXFbRVn9yuCZ0c2St76 I6TES3YqYXO0x4QF+6CRvN8MKcchAn8lGBi8DrWgR5mNZzgN4Y81tpvSHNQJgkDN E/yzGzEJXL1/itvjgOUNV/rIqhaUIPHfam2Ec5vvGqEYRn6yeOlIjCps/6dNugIm 6y+/M/N8fQcwjjI3XNYk7WQcEeEF9Ry0V/3B7GcoN2c6qdkYyGbvhRUIrErg/Nwn YklYITApS/M/bttdN8cUwBYLEqRlNdwdHdORPEni534mpRTfe59FA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:message-id :mime-version:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; bh=QLv7UvOJ2eVWE+O8IgsNEqMHHTiRM7NYtdErP2qDfLs=; b=eptS3odL aGb4P3DMZjxf0BwLkbXTExLyRCFKeCsLIG7kYnPBQxBpyoF2JzNrx0q/TtaEatkV Pd4Uv6P3J3Y5MTLp7GNM8+NvxrCndnvRLVi/NvGKRwFTEiFassSW0eEZ6hEiofow e1ge6xfdPwn2ekdfr6c3Uyo29QlYYIJ14cmA2rNPBN95pF4/ai18Adek4l73iMTq EOqE2jOAwxTPmq3zcsBX2kJ9G0+S89oxcRzrU+8u3H4Q02Elx7bbqGUIZK5CtZLO wH8nc5XwpBlKP0lG+xo5PyYcBsuzN4AND7QSyaN8xxUb2s5bY64vRNzu9UCLH1KS cJKdOC94FnloiQ== X-ME-Proxy: X-ME-Sender: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id A5667E4621 for ; Thu, 23 Aug 2018 03:58:08 -0400 (EDT) Date: Thu, 23 Aug 2018 16:58:00 +0900 From: Michael Paquier To: Postgres docs Subject: "System roles" mentioned in psql documentation Message-ID: <20180823075800.GA30782@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Fba/0zbH8Xs+Fj9o" Content-Disposition: inline List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Fba/0zbH8Xs+Fj9o Content-Type: multipart/mixed; boundary="wac7ysb48OaltWcw" Content-Disposition: inline --wac7ysb48OaltWcw Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Hi all, I have noticed that psql documentation mentions "system roles", however in all other parts of the docs, we use the term "default roles". Shouldn't we make this term more consistent and also add a link to the table describing those roles? Please see the attached. Thanks, -- Michael --wac7ysb48OaltWcw Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="psql-system-roles.patch" diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index eb9d93a168..df762b811c 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1521,7 +1521,8 @@ testdb=> unified into roles, this command is now equivalent to \du.) By default, only user-created roles are shown; supply the - S modifier to include system roles. + S modifier to include default roles described in + . If pattern is specified, only those roles whose names match the pattern are listed. If the form \dg+ is used, additional information @@ -1711,7 +1712,8 @@ testdb=> unified into roles, this command is now equivalent to \dg.) By default, only user-created roles are shown; supply the - S modifier to include system roles. + S modifier to include default roles described + in . If pattern is specified, only those roles whose names match the pattern are listed. If the form \du+ is used, additional information --wac7ysb48OaltWcw-- --Fba/0zbH8Xs+Fj9o Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlt+aQgACgkQnvQgOdby QH0bvA//VuZKnMOPkHbV+oT5CGs+LaoBj8ukaF72IwrC9BooSOOIyTEb+jSTSHh1 Q9Z2CyA0kDyX26zZCdv7zOG+QpsUZlCmUuwdkB7rTqttWTxNTidODJPepRwaSpic FNFFEB5amqYN3biaxMmoT2y/b5B8OanSvnrqwRTBkUmPGsqlZhpzZPQJjMXje/WC PLuOPYQDRK4vUcLxi3Rn9gIU1fUEM5ACHhPpjZLBxvlLZoyfHpTEl3n3RrwGRlN6 Y05+alUhIAVZQ35kwveoGaIohV2eovQLsY3j/m31kGFcfJjpCcbSTziDy5mvmBm5 yWKfNPa6ioYHNZrFOFIm46hSjavVowGwo2qMkjCyzoQ2rBTXT2Mos04ktxbVbV+i jGHKWe6wgQQNhi/4Wi39pVlWQJXunoyWQt36YcnkEG9DgYr/E85rQiiRgIjbYBLS Tndu5F5MlDXUt3kpJiwZ0Fd1l3ta2Xp5TN+lBwvknjp29ssteXJ1yQ0Mf4gytq6L gTXbeeoYMrGthQXbXn2Ed6OnVuqmBllswrAD7SJknJXGXM1SwQKwGlmpc6le858H usroSQvf2ffPSzTZnyB7RLwVBilCRGGpRJUTE18+SCTec6iwQAcbyFbOsjWsE+Uk DzLJkZ0asAkQX3g1mdAj14IBgkIj2LXyucsPJo5uYjsVRRBxHnU= =nGOb -----END PGP SIGNATURE----- --Fba/0zbH8Xs+Fj9o--