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
[email protected]
