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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vC74J-0099uZ-La
	for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Oct 2025 01:58:15 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vC74H-00D4m1-4s
	for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Oct 2025 01:58:12 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <quanzongliang@yeah.net>)
	id 1vC74G-00D4ls-RZ
	for pgsql-hackers@lists.postgresql.org; Fri, 24 Oct 2025 01:58:11 +0000
Received: from mail-m16.yeah.net ([1.95.21.14])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <quanzongliang@yeah.net>)
	id 1vC749-003SKF-1A
	for pgsql-hackers@postgresql.org;
	Fri, 24 Oct 2025 01:58:09 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yeah.net;
	s=s110527; h=Message-ID:Date:MIME-Version:Subject:To:From:
	Content-Type; bh=cN4ijXopUoyZnE80Gug1HNDytHjAqZqBQAVkl1Whtbc=;
	b=lmvdi/yH55UbtLbWyC6HN+jBoFl1K6PXfHr7slICYZNgbqJHYQErmjcJ+Prh3q
	c/pc7rzj392A9qK0w0D7NfCO1RZAOSkPknXOzglGE/dWEuC2teb6cbtxuh05JaN4
	nf0jxg8YpTiV3Q3MVkqjif/V+PbMT18qLj6pqLxZxSr+s=
Received: from [192.168.10.60] (unknown [])
	by gzsmtp2 (Coremail) with SMTP id Ms8vCgDnD1og3fpome6LAA--.33874S2;
	Fri, 24 Oct 2025 09:57:52 +0800 (CST)
Message-ID: <5f8b90df-b5fa-48ac-9931-f1608310cb52@yeah.net>
Date: Fri, 24 Oct 2025 09:57:51 +0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Include extension path on pg_available_extensions
To: Euler Taveira <euler@eulerto.com>, Chao Li <li.evan.chao@gmail.com>,
 Matheus Alcantara <matheusssilv97@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
References: <DCTSKQAVOXIG.3A05JM1YORARK@gmail.com>
 <0DDF33A5-4F8C-4725-A124-B301147FA1FA@gmail.com>
 <5aaee744-342c-4ec8-a2ef-ffa0969cc51c@app.fastmail.com>
Content-Language: en-US
From: Quan Zongliang <quanzongliang@yeah.net>
In-Reply-To: <5aaee744-342c-4ec8-a2ef-ffa0969cc51c@app.fastmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-CM-TRANSID: Ms8vCgDnD1og3fpome6LAA--.33874S2
X-Coremail-Antispam: 1Uf129KBjDUn29KB7ZKAUJUUUUU529EdanIXcx71UUUUU7v73
	VFW2AGmfu7bjvjm3AaLaJ3UbIYCTnIWIevJa73UjIFyTuYvjxUIqXHDUUUU
X-Originating-IP: [117.10.92.190]
X-CM-SenderInfo: htxd06xrqjzxxdqjq5hhdkh0dhw/1tbiNABYfGj63SD4iAAA3P
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>
Archived-At: 
 <https://www.postgresql.org/message-id/5f8b90df-b5fa-48ac-9931-f1608310cb52%40yeah.net>
Precedence: bulk



On 10/23/25 9:56 PM, Euler Taveira wrote:

> 
> * insufficient privilege: if the role doesn't have the sufficient privileges,
>    return NULL or '<insufficient privilege>' (similar to pg_stat_activity). I
>    don't have a strong preference but the latter can impose more effort to use
>    if you don't know the role has sufficient privilege. However, it is clear why
>    the absolute path is not returned.
> 

+1
I think this way is better.