[postgis-users] "postgis-3" extension in PostgreSQL extension list of pgAdmin

[Marco Boeringa]

Hi Regina,

Your query shows me the same "3.1.4" 'default_version' for both the 
'postgis' and 'postgis-3' entries in the table, so no difference 
contrary to your expectation.

The same for all other duplicate "*-3" entries for e.g. 
'address_standardizer-3', 'postgis_raster-3', etc., they all point to 
the same "3.1.4" 'default_version' as the non post fixed ones.

By the way, only a small part of the extensions is duplicated like that, 
the address stuff and postgis related, the rest only has a single entry 
in the table, without "*-3" extension.

Marco

Op 3-11-2021 om 22:09 schreef Regina Obe:
> Doesn't matter where pgAdmin is run you'd see the same issue since it just reads the extension tables from the server.
>
> If you do the query
>
> SELECT * FROM pg_available_extensions;
>
> I suspect you'll see two and they have different default versions.
>
>> -----Original Message-----
>> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
>> Of Marco Boeringa
>> Sent: Wednesday, November 3, 2021 2:01 PM
>> To: postgis-users at lists.osgeo.org
>> Subject: Re: [postgis-users] "postgis-3" extension in PostgreSQL extension list
>> of pgAdmin
>>
>> Minor correction / addition to the below specs: PostgreSQL runs on a VM with
>> Ubuntu 20.04.3 LTS as OS, pgAdmin4 is run from a Windows 10 machine.
>>
>> Op 3-11-2021 om 18:06 schreef Marco Boeringa:
>>> Hi Regina,
>>>
>>> It is Ubuntu 20.04.3 LTS, with PostgreSQL 13.4. PostGIS is at 3.1.4
>>> after enabling the "postgis" extension in pgAdmin4 (v6.1).
>>>
>>> Marco
>>>
>>> Op 3-11-2021 om 18:00 schreef Regina Obe:
>>>>> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org]
>>>>> On Behalf
>>>>> Of Marco Boeringa
>>>>> Sent: Wednesday, November 3, 2021 9:11 AM
>>>>> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
>>>>> Subject: [postgis-users] "postgis-3" extension in PostgreSQL
>>>>> extension list of pgAdmin
>>>>>
>>>>>     Hi all,
>>>>>
>>>>> Having to re-create a database using pgAdmin, I just wondered what
>>>>> the "postgis-3" extension represents that is visible in the list of
>>>>> suggested extensions in pgAdmin? I have always ignored the entry,
>>>>> and chosen "postgis", which seems to work fine, but I have never
>>>>> quite understood what the "*-3"
>>>>> post fixed extension objects are (e.g. there is also a
>>>>> "postgis_raster-3" visible next the to "postgis_raster" one).
>>>>>
>>>>> Can someone explain?
>>>>>
>>>>> Marco
>>>>>
>>>> [Regina Obe]
>>>> Are you running Debian or Ubuntu?  I think that is a specific packaging.
>>>> I recall seeing that funniness on a Debian install.
>>>>
>>>> The extension should just be postgis, but I think for some reason
>>>> they also created an alias -3 to differentiate it from postgis (which
>>>> the default version might be 2.5 depending on what OS you are on and
>>>> the default version for the -3 would be 3.something.
>>>>
>>>> So they had essentially created two postgis.control files one
>>>> postgis.control and one postgis-3.control so they could control the
>>>> default for each.
>>>>
>>>> I'd just try using plain old postgis and in the drop down of
>>>> versions, see if you see a 3.something
>>>>
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at lists.osgeo.org
>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users