Postgresql python in upgraded version 16.2

From: Šika Michal <michal(dot)sika(at)spcss(dot)cz>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Postgresql python in upgraded version 16.2
Date: 2024-06-20 05:05:31
Message-ID: AS8PR03MB8781D94903B5866E14BB81DD91C82@AS8PR03MB8781.eurprd03.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry O Litvintsev 2024-06-20 07:23:38 Help. The database was created using collation version 2.17, but the operating system provides version 2.34.
Previous Message Maxwell Dreytser 2024-06-20 01:22:23 Re: RowDescription for a function does not include table OID