Re: Only one version can be installed when using extension_control_path

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Monday, September 8, 2025, Matheus Alcantara <matheusssilv97(at)gmail(dot)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.

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