Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f8HIv-0002YE-Fv for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Apr 2018 03:29:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f8HIu-0007WF-9i for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Apr 2018 03:29:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f8HIs-0007W5-Ht for pgsql-hackers@lists.postgresql.org; Tue, 17 Apr 2018 03:29:12 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f8HIn-00089Z-5y for pgsql-hackers@postgresql.org; Tue, 17 Apr 2018 03:29:10 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 4E9F621839; Mon, 16 Apr 2018 23:29:03 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Mon, 16 Apr 2018 23:29:03 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; bh=kkb2ulMlkcgy1pno/LXShEgdhGYsuSIehkR/O7wEFeo=; b=NKdjheh+ nWGMieqgE1MJOtC5f6hD4CguqsJF3mDxIclHG419Mi7li3XVdAYNU6QIUhvMORn5 tz3U969/WyiK7+eEARr0ymhK08YNQuK8GcMfPzmap7V6wkj9U2T9HTZ5RnIKKQky z7dA8WA+kT8M7ewbjIKhuxB9BlNhC1kxI3ou0ULGo7+pOh/7/Zyx3Jj14drV4nh5 OwUT/9nmw+jEMBctvbHnrE0DDAC0gFyKjFbwtuZ3yxfnXruH+SD810lb3f8ILrmy mqL5j3nll7k028k+XqlpgW6hmP3S2TsftyWmmAr8+SHnSCw6v/hPuf/eAFSzewvA M9Y8PFtAHGHpKA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; bh=kkb2ulMlkcgy1pno/LXShEgdhGYsu SIehkR/O7wEFeo=; b=iQk9Zfo5PiRuInaJeZHRWZT5+irhX7pcZDdAJ2hGpqjqz b05zF43RBJs45ix6wrETT5TtD63VJ7uZw4zVp07H03QI2iBXCml4zRuQsDdNjsUd WU/HQ/Mc0/7TaWL6mMNpII3SvXlbG1ZXHEHa/rUzbOCBHSndrCqyO7Lo8G5luXNo mv5qgDldkqTZ2y9324yFX+wCEqOo9wIwr/q9XNOu1ORwOAzZTK+oqZThH1W2ve51 omhLSAHljwalm5njofKzzKkwES72Rxiu5MnMrWRdup6bKopX+hNRIoIYDEynvbQm kNLbUo9AVChJPHtRlFY0RwrK/0Z9K7Gv8nHK9n20Q== X-ME-Sender: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id AA4F3E43AC; Mon, 16 Apr 2018 23:29:01 -0400 (EDT) Date: Tue, 17 Apr 2018 12:28:58 +0900 From: Michael Paquier To: Laurenz Albe Cc: pgsql-hackers@postgresql.org, simon@2ndquadrant.com Subject: Re: SHOW ALL does not honor pg_read_all_settings membership Message-ID: <20180417032858.GD4998@paquier.xyz> References: <1519917758.6586.8.camel@cybertec.at> <1523881930.3779.37.camel@cybertec.at> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="9dgjiU4MmWPVapMU" Content-Disposition: inline In-Reply-To: <1523881930.3779.37.camel@cybertec.at> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --9dgjiU4MmWPVapMU Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Apr 16, 2018 at 02:32:10PM +0200, Laurenz Albe wrote: > Now that the dust from the last commitfest is settling, I'll make a second > attempt to attract attention for this small bug fix. >=20 > The original commit was Simon's. Thanks for the ping. This was new as of v10, so this cannot be listed as an open item still I have added that under the section for older bugs, because you are right as far as I can see. GetConfigOption is wrong by the way, as restrict_superuser means that all members of the group pg_read_all_settings can read GUC_SUPERUSER_ONLY params, and not only superusers, so the comment at least needs a fix, the variable ought to be renamed as well. -- Michael --9dgjiU4MmWPVapMU Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlrVafoACgkQnvQgOdby QH3Rcw//R5oHgazY/ij3qd2lJc9WPu9lXmEPLtTgZnudcAwUJytLrHRTaCNaoQtZ f4GbTZozNeNq0FMUWBdbYiJ3NylPcBMqUnSVCnGzFfFQm8JP6Tan462NdBaDDrLA 9jcWOFZdrQINPt7Tb2IS6qdKc6BC4J42MgGEbnHUkEZDqUhZ6SpByDIpFOHsUOKs DskDnnkc6k6c5WiucrLczjl137j896wa/3bXZ6bbUDLAQSu7lg2/9R40blZCppfB 8sKoNt+PJo+ycgv1Ajp8LKNPbpuMsr3gEiqrMlnGymBlZCFp7qqTDy3gpbalecDf TETfteN9dS6X6uk54G1Cg6fjq3el3ZJSxEqXJ/8BSHrWLnZYOnQ3L++40d35aTx0 h2FmulpO2pmXVDjyHevDw2HCg++lTbIQuEbqd8zdplmITOShTgVF3VIcKc3NalY6 N2wzq1hB8sRiVRjgfiZ6z+H2LWBDaJX6JqmmU/0vZHf+S2n2Yp7fSWDenwTWhp44 /8u/muG2NIeEFlMHMCkDV3q2klGCiDRA9yGr1Ce/iXt0lc+fQiTX2Rti5GtihL/3 bwPGWhoc/m3Fl2xEN6DgPAOGxjfw0cSnl/6+a9wUlNaQXSvLakyWiqEvxAndlSni 690itm+iJr5uZ9h89xc6JAZThhvF6V4XG0egd18W5yYaEHcGBRY= =upE8 -----END PGP SIGNATURE----- --9dgjiU4MmWPVapMU--