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