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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1fRMlB-0002JE-SK
	for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Jun 2018 19:09:17 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1fRMlA-0008U9-ED
	for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Jun 2018 19:09:16 +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 <alvherre@2ndquadrant.com>)
	id 1fRMkS-0003bf-Mt
	for pgsql-hackers@lists.postgresql.org; Fri, 08 Jun 2018 19:08:32 +0000
Received: from mail-qk0-x241.google.com ([2607:f8b0:400d:c09::241])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1fRMkP-0003Hz-6O
	for pgsql-hackers@postgresql.org; Fri, 08 Jun 2018 19:08:30 +0000
Received: by mail-qk0-x241.google.com with SMTP id j80-v6so9397058qke.9
        for <pgsql-hackers@postgresql.org>;
 Fri, 08 Jun 2018 12:08:28 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:cc:subject:message-id:mime-version:content-disposition
         :content-transfer-encoding:in-reply-to:user-agent;
        bh=MuBhKNdFlkYAvZzwefoSgxzFELTZzgUZ9NDV87N5EWs=;
        b=o9nFtKIwXZLXJu96SKk6boZ1TLnMO2mb0tFb8oZsy/Y3qVb6hIhm0AyfX9QzZBF1Pr
         UOURtK03+jyNCsO/49MJX1FwwimC4BUETvrp/T3wzT1jCrgPXRMirjO0cvfYyp6nX84e
         MHYFXkbv9eENMgtn7L7HjQx7dWh6+5wE8TULhXLpsURnvIhQKKrCBJgvwXhVM0tPyDhV
         y72k+Wlv6HWQXCZPyoi7qVLXtymAjMpUi+lnOFockaO1yz+l6LRjitr3lnjs69+ThMbI
         jk26MLcJ0n0I4cJjlTyG7t2MafmOQ0aPyHeRF7CrO4iH745KRzVOIMQ7pO3OUqpAyzpV
         m+XQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version
         :content-disposition:content-transfer-encoding:in-reply-to
         :user-agent;
        bh=MuBhKNdFlkYAvZzwefoSgxzFELTZzgUZ9NDV87N5EWs=;
        b=IBb16AUm8ZTfqfVLMq8KdnKuJ9uomRWgxCLurWC2ugnIFReT9YPpbjfXbcea2M0dz6
         GzkX2cIf+9aosQy6mX0bO1g6tXl5ZImIdYbi+4L0VZg8VX2nbjMIoZCalIkAsfd/gTOe
         0lIpsnBI/YGq4XBuuqsOcqabcIINiyEN17STjER0JIqQ2VvytQaekndHQakolox/I25q
         x9KtUxODpsUryxM6Q4ksWgZyAXqNb0SEvQyIY1FXKy+owniVswlGGmK1DrKkNy6yDoMT
         kBTu/Vk/q+dRY5jK0mOavkoM5ppyIUDXSg95hqa4nkyAW4jD2x1oLOFrbXVPDNOo4sln
         klig==
X-Gm-Message-State: APt69E2paphytVsP+Wf6lm2Rm7PgUPBYrRzmvsCmvXgHST5Tn0axiytO
	uDt2nYCPvrWiJllq9PMm/8fbxA==
X-Google-Smtp-Source: 
 ADUXVKKySAyM8OUOzOXms3caDWm8VYsxvnu/jUu+e3I8krc7/jaIVSZNLO7lcCinDxR8SgljKfZQGw==
X-Received: by 2002:a37:d746:: with SMTP id
 m67-v6mr6435274qki.267.1528484908084;
        Fri, 08 Jun 2018 12:08:28 -0700 (PDT)
Received: from alvin.alvh.no-ip.org ([190.121.29.3])
        by smtp.gmail.com with ESMTPSA id
 f17-v6sm3061623qtp.1.2018.06.08.12.08.27
        (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256);
        Fri, 08 Jun 2018 12:08:27 -0700 (PDT)
Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000)
	id 41EE4A3C; Fri,  8 Jun 2018 15:08:25 -0400 (-04)
Date: Fri, 8 Jun 2018 15:08:25 -0400
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Simon Riggs <simon@2ndquadrant.com>,
	Laurenz Albe <laurenz.albe@cybertec.at>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: SHOW ALL does not honor pg_read_all_settings membership
Message-ID: <20180608190825.um2yhnuizffutozx@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20180607212357.aiq4wuqz3fqwe3mu@alvherre.pgsql>
User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0)
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

BTW a further bug here seems to be that "select * from pg_settings()"
does not show the source file/line for members of the role, which seems
to be documented to occur.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services