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
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 |