Postgresql python in upgraded version 16.2 - Mailing list pgsql-general

From Šika Michal
Subject Postgresql python in upgraded version 16.2
Date
Msg-id AS8PR03MB8781D94903B5866E14BB81DD91C82@AS8PR03MB8781.eurprd03.prod.outlook.com
Whole thread Raw
Responses Re: Postgresql python in upgraded version 16.2
List pgsql-general

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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Transaction issue
Next
From: Dmitry O Litvintsev
Date:
Subject: Help. The database was created using collation version 2.17, but the operating system provides version 2.34.