TLP:AMBER

Hello all,
I upgraded version of Postgres from 13.5 to newest 16.2. But Python was not 
upgraded.

I create procedure pyver():
CREATE OR REPLACE FUNCTION pyver ()
 RETURNS TEXT
 AS $$
     import sys
     pyversion = sys.version
     return pyversion
 $$ LANGUAGE 'plpython3u';

On the Postgres 13.5 I get this result:
# psql -d database
psql (13.5)
Type "help" for help.

postgres@database # select pyver();
                  pyver
-----------------------------------------
 3.6.8 (default, Aug 13 2020, 07:36:02) +
 [GCC 4.8.5 20150623 (Red Hat 4.8.5-39)]
(1 řádka)

postgres@database #

On the Postgres 16.2 (upgraded from version 13.5) I get this result:
# psql -d database
psql (16.2)
Type "help" for help.

database=# select pyver();
                  pyver
-----------------------------------------
 3.6.8 (default, Jan  5 2024, 09:14:44) +
 [GCC 8.5.0 20210514 (Red Hat 8.5.0-20)]
(1 row)

database=#

It seems python was not upgraded when I upgrade PostgreSQL. Is possible upgrade 
the python to actual version 3.9.x installed on RedHat 8.5 ?

Thanks
Michal


TLP:AMBER

Reply via email to