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.kla...@aklaver.com


Reply via email to