Re: pg_upgrade Python version issue on openSUSE

On 9/26/20 7:35 AM, Paul Förster wrote:
> Hi Tom,
>

> just checked with another 12.4. It's the same:
>
> postgres=# select * from pg_available_extension_versions where installed;
> name | version | installed | superuser | relocatable | schema | requires | comment
> ---------+---------+-----------+-----------+-------------+------------+----------+--------------------------------------------------------------
> plperlu | 1.0 | t | t | f | pg_catalog | | PL/PerlU untrusted procedural language
> dblink | 1.2 | t | t | t | | | connect to other PostgreSQL databases from within a database
> plpgsql | 1.0 | t | f | f | pg_catalog | | PL/pgSQL procedural language
> plperl | 1.0 | t | f | f | pg_catalog | | PL/Perl procedural language
> (4 rows)
>
> postgres=# drop extension plpythonu ;
> DROP EXTENSION
> postgres=# create extension plpython3u ;
> CREATE EXTENSION
>
> The "plpython" and "plpython3u" for the drop and create extension statements came by entering "plpy" and then pressing tab. So PostgreSQL knew about them. Still, as you can see, I could drop pypythonu again though it did not appear in the query. After the create extension, it appears as it should:
>
> postgres=# select * from pg_available_extension_versions where installed;
> name | version | installed | superuser | relocatable | schema | requires | comment
> ------------+---------+-----------+-----------+-------------+------------+----------+--------------------------------------------------------------
> plperlu | 1.0 | t | t | f | pg_catalog | | PL/PerlU untrusted procedural language
> dblink | 1.2 | t | t | t | | | connect to other PostgreSQL databases from within a database
> plpython3u | 1.0 | t | t | f | pg_catalog | | PL/Python3U untrusted procedural language
> plpgsql | 1.0 | t | f | f | pg_catalog | | PL/pgSQL procedural language
> plperl | 1.0 | t | f | f | pg_catalog | | PL/Perl procedural language
> (5 rows)
>
> Is this a bug in 12.4 not showing the extension?

Could it be that at some point in these instances history plpython*
where installed as CREATE LANGUAGE and you are dealing with the vestiges
of that?

Are you able to go back and reconstruct them and then do \dL (languages)
and \dx (extensions)?

>
> Cheers,
> Paul
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com