Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjeHv-002awm-Ru for pgsql-committers@arkaria.postgresql.org; Thu, 29 Aug 2024 12:30:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sjeHs-001bNM-3h for pgsql-committers@arkaria.postgresql.org; Thu, 29 Aug 2024 12:30:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjeHr-001bNE-SZ for pgsql-committers@lists.postgresql.org; Thu, 29 Aug 2024 12:30:04 +0000 Received: from fout2-smtp.messagingengine.com ([103.168.172.145]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjeHk-00250z-Qv for pgsql-committers@lists.postgresql.org; Thu, 29 Aug 2024 12:30:03 +0000 Received: from phl-compute-08.internal (phl-compute-08.nyi.internal [10.202.2.48]) by mailfout.nyi.internal (Postfix) with ESMTP id 08449139010B; Thu, 29 Aug 2024 08:29:56 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-08.internal (MEProxy); Thu, 29 Aug 2024 08:29:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s=fm3; t=1724934596; x=1725020996; bh=jz6ikcA4UQxZVh8V0vsWmOpcD8DHjRlH D87lguXtSro=; b=X2EE9nlNW++ThP7xFILK3c3tiN0wSFIWpIvxvTjDsvsOdjKc QtJD/xkQfWdEC9QhTCBQc8KwxG2aQ5egG8gJjJScyMejw59saF+/A92hB/x91lRo UzdlC5OiFGYYc9BcGr4zGUERsyxw3eFa9A4L1OLU63xm+3xc7ekqNhU19eHCIp3Z avDQ5H/muk+KYTw1h4CYnF6oWGAM9EqceSFz1PLp7KhPJuldNkeyDgFQQGFnwr4m KGFWC8yA0HsuzXDwInr4+xI7TEUOjqsBL8QWPZqJwFXf1hG7zk+fJX3v3lD59hmJ EDXh496oWlE3yPZRqlQM0oCzdgkR6FRBnTj4yA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1724934596; x= 1725020996; bh=jz6ikcA4UQxZVh8V0vsWmOpcD8DHjRlHD87lguXtSro=; b=N zf8EKtcPK6D5iF7smk+TJ3Lpj3K5G7CBInhwFxCweZwemHZx3n95sp/uR6xKSG6c hswsQgbE+MD8RDYbspli5T5zv8afvup7eQw/FMGNceYPOWc3s7N2TntSW7gDrdYA cg6hsBoRPzi5un8bZLEeVcA7R0F78MFtv6SAvdoXXR7gKwhqSYYrUdwn9LDH8J5h UnVCFLTUK7D9WGwgbLjoC4WP/JvoOa5+WbXrG6OtydWtlb0ryY6SJRJIf6La5gNP 2uqQsAKauSHR6lFDZ0QN0EqX9YEmWsWmA8oqpCIUFp5hd+lMbRClryymlEho4rlu cGrGiXF5nqq7LtGwkP3nQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrudefgedghedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddtvdej necuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvg hnthhrrghuthdrohhrgheqnecuggftrfgrthhtvghrnhepjefhveehtdetgfffhffhfeef gffghffflefgieeuueekhedvhedvfeehffdvfeeunecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdho rhhgpdhnsggprhgtphhtthhopeefpdhmohguvgepshhmthhpohhuthdprhgtphhtthhope hsrgifrggurgdrmhhshhhksehgmhgrihhlrdgtohhmpdhrtghpthhtohepthhglhesshhs shdrphhghhdrphgrrdhushdprhgtphhtthhopehpghhsqhhlqdgtohhmmhhithhtvghrsh eslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 29 Aug 2024 08:29:54 -0400 (EDT) Message-ID: <289a0af8-59c4-459f-a352-2a8427d47173@eisentraut.org> Date: Thu, 29 Aug 2024 14:29:53 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pgsql: Restrict accesses to non-system views and foreign tables during To: Masahiko Sawada , Tom Lane Cc: pgsql-committers@lists.postgresql.org References: <6a96f1af-22b4-4a80-8161-1f26606b9ee2@eisentraut.org> <8dbff88c-d1cc-4c4d-a016-1c538c7cf9bd@eisentraut.org> <3039986.1724765383@sss.pgh.pa.us> Content-Language: en-US From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 27.08.24 22:02, Masahiko Sawada wrote: > On Tue, Aug 27, 2024 at 6:29 AM Tom Lane wrote: >> >> Peter Eisentraut writes: >>> Maybe in the documentation it would also be appropriate to mention that >>> this is meant to be used by pg_dump, not for general use -- unless it is? >> >> I'd vote against that. I think other catalog-scanning tools might >> like to use this too. >> > > I've attached the patch to improve the descriptions while leaving this part. Thanks, I find this clearer.