Re: Only one version can be installed when using extension_control_path

On 08/09/2025 17:35, Tom Lane wrote:
> "David G. Johnston" <david.g.johnston@gmail.com> writes:
>> On Monday, September 8, 2025, Matheus Alcantara <matheusssilv97@gmail.com>
>> wrote:
>>> On this step it will search the .control
>>> file on paths at extension_control_path in order and it will use the
>>> first one that it finds and based on the .control file found it will
>>> install the extension using the version specified on the command.
>> Then pg_available_extensions seems broken - it lists extensions as
>> available that are not accessible to the user due to this policy.  Maybe we
>> need to add something indicating that certain rows are hidden behind the
>> present path setting which would need to be changed if one wishes to
>> install them.  Also seems like the extension location should be part of the
>> output too.

I agree. If an extension is the list, I expect to be able to install it.

Either :
- we hide the latest version found in paths in pg_available_extensions ;
- we give the possibility to install all listed versions.
The second option seems more relevant to me.

Adding extension location is a good idea.

> Between this and previously-identified problems (commits 81eaaa2c4,
> f777d7738), it seems clear that extension_control_path (which is a new
> thing in v18) was very poorly thought out.  I wonder if it's too late
> to revert it so that we can redesign it more carefully.
>
>             regards, tom lane