Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKDuC-008vpr-FC for pgsql-general@arkaria.postgresql.org; Thu, 20 Jun 2024 09:16:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sKDuA-002wGj-5U for pgsql-general@arkaria.postgresql.org; Thu, 20 Jun 2024 09:16:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKB0Q-00010I-SP for pgsql-general@lists.postgresql.org; Thu, 20 Jun 2024 06:10:47 +0000 Received: from mail-he1eur01on2135.outbound.protection.outlook.com ([40.107.13.135] helo=EUR01-HE1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sK9zN-002aHX-CI for pgsql-general@postgresql.org; Thu, 20 Jun 2024 05:05:39 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=K8DtoaOXzasbp4Lv6NRycLbyma40QiV80QT9AwQavK7e4eWTDKRJh+zZ22OjA00+qrAan8JUc+HxXsWDrSs/5KYClYSVAB6lmnuept8RQnqhVsFFZ88lxFXalSAukkDU6njJS9MSfugpRXaYi4g0VI5O+pdptIv8sk2Owc1rhkzQUZ9xJ3otCbSJ1UxvXgWslxSyvcleKfluae/A9xSbK9xG7LF8j0mM4Qs3F1zWj1gftKZC9YmTx30QltwsfoEBUTruPK2jea2/4oHoUzgGjHBfhcMIeoej5nOnd6fmvlefnnDtZy0R1PkoeQQXCl9PQKDbCq8Rpii8vDD8yFfkcA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=vSMWGFpYb2U8iWaOkwPD0EyAw2lXwtcADlWPuRmy+Vk=; b=GggnGOxsY/2c8shVsS5AnD8zjonAcyY0xLLthyjwrxR6zmexeJ5hymLLpZxdU+JZwiBlzgU/c6CnXR4LqOTjde06JILVs82uhbmuS+l3uWICZAC5vHIu++aAAwOL4i+JanK+gYHD8RFhqsbO0KYaR0szYockvlmE9WlUBUQdZk/c6quV9R4XpdMTcwZx9U2za/Tk8A2Xxmefy2y7r5yLoFRtycahuL05qykWBJk6MX6RaqtnE/hk0xc3N9VcJFFwHlp4Gnx8kzkPQQAz0wyHw5JWwJWMv/4nC6Dx+i1dOGZkChYSMV0LzEfYBjrMViefRrduAj+Qz/S1eLw2fpXsiQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=spcss.cz; dmarc=pass action=none header.from=spcss.cz; dkim=pass header.d=spcss.cz; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=spcss.cz; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=vSMWGFpYb2U8iWaOkwPD0EyAw2lXwtcADlWPuRmy+Vk=; b=HUHgyrM4j6WEDL4pMLh6spr0JtK9z8e+u5gA04CcGe/y58B0EfJT7pXEfUhjooFS+mgfI1fJvT2ly7I5PVoM5yi0IgNmz9UWNXmrDK4dY4UcMuDAtrOnCdSlGLf6I5tVKIY6XeCOtUFRRKFdeLqsHPAKKuOMbD66fkcYDktI8kyODOd3yq3Y70CzWblTy/E7MCgzY93omBCPkhpi9yTHlHeq7Hmxe2n8zZ+e4DR64G4MAdEZFeHyD2sjZ7oQ9mmLXZz65k77/xktk3V1VjHcDPLw9dRgCEp2ibnkMy2IEO6ZLmlyUZrN8IcJmFuXRG3lqXluHfxiCNF7vXNvrUbUtw== Received: from AS8PR03MB8781.eurprd03.prod.outlook.com (2603:10a6:20b:53e::18) by GV2PR03MB9500.eurprd03.prod.outlook.com (2603:10a6:150:dc::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7698.21; Thu, 20 Jun 2024 05:05:32 +0000 Received: from AS8PR03MB8781.eurprd03.prod.outlook.com ([fe80::b1e3:204:746f:2cb6]) by AS8PR03MB8781.eurprd03.prod.outlook.com ([fe80::b1e3:204:746f:2cb6%3]) with mapi id 15.20.7698.020; Thu, 20 Jun 2024 05:05:31 +0000 From: =?iso-8859-2?Q?=A9ika_Michal?= To: "pgsql-general@postgresql.org" Subject: Postgresql python in upgraded version 16.2 Thread-Topic: Postgresql python in upgraded version 16.2 Thread-Index: AQHaws4jzNjpxT61rES9fUU0L7+Suw== Date: Thu, 20 Jun 2024 05:05:31 +0000 Message-ID: Accept-Language: cs-CZ, en-US Content-Language: cs-CZ X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_22c5d95a-8ae7-458f-9507-70e0cc24520d_Enabled=True;MSIP_Label_22c5d95a-8ae7-458f-9507-70e0cc24520d_SiteId=8ef2ef64-61e6-4033-9f7f-48ccd5d03c90;MSIP_Label_22c5d95a-8ae7-458f-9507-70e0cc24520d_SetDate=2024-06-20T05:05:31.501Z;MSIP_Label_22c5d95a-8ae7-458f-9507-70e0cc24520d_Name=TLP AMBER;MSIP_Label_22c5d95a-8ae7-458f-9507-70e0cc24520d_ContentBits=0;MSIP_Label_22c5d95a-8ae7-458f-9507-70e0cc24520d_Method=Standard; authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=spcss.cz; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: AS8PR03MB8781:EE_|GV2PR03MB9500:EE_ x-ms-office365-filtering-correlation-id: c2e6ea41-a0f2-4c6d-e7a3-08dc90e69c35 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230037|1800799021|366013|376011|38070700015; x-microsoft-antispam-message-info: =?iso-8859-2?Q?t2DD89J4cIA9nZYxbPBkjX+vR6MikT+D7Cj9LdcXwFZaWCaw5n+TovdsV/?= =?iso-8859-2?Q?LWyqdF0e90FT94uUV9drcVKMcXndF+uaPb7KiNyTWXoB61qndFijzVNxrj?= =?iso-8859-2?Q?kXTuKBJQ2FG84dlpZ4oxosU/Zuj2J3U7MYE6hBNWP0JcGUhmONZWKoi6ii?= =?iso-8859-2?Q?pmvwIzerAy17s6MeedbrCUGHy6P5bOCSgUM+2v3iVm9KSVDR95HFsajnCY?= =?iso-8859-2?Q?bFQj15zFZCr1FBdN8kXXcdsoRK3sd8owqyYNymbqLlIRbvQkMLsGfZ4mYQ?= =?iso-8859-2?Q?ciRmLnvwt9pPyWB6NH5MeWlMEA8GJrvP/omK5mmb3Z64ACo32Q9GmcSK4o?= =?iso-8859-2?Q?Wnpt1gpGTUddtwSyQz9buQTtYAPypZDmXAFr9N3tJWE820TC+GC/hpiVO3?= =?iso-8859-2?Q?SfpxUJH3GEbd+ULSpD1gZ/nM1nb1INt/5xU0s123bo2DRynsDzeyIqjWL/?= =?iso-8859-2?Q?AIgpmHqUEgkS+20g0l2bhbP99l5sED870Eq8l1i3fCgzY/eQxxsVsfrqxW?= =?iso-8859-2?Q?Li7TQEQRUZSJYWkUTiGghpo87eGua27G3iZRf964sDbKaAECtIwjoDMzid?= =?iso-8859-2?Q?2k5yPQOjFZ6rlw3d9fsUuGCJxkG+EZBwqxZtBXgArwNqLUxKi6K7WH1Ckr?= =?iso-8859-2?Q?byLceVXtxko60sy8M5DuPsiYuScML1uUlDcHpEDzj1VmN+Wd5dAx6Cn/ky?= =?iso-8859-2?Q?nq27iQv+IF3j3B0vdOgzr2FD0EubUpGu0XBKZxzBCcZm4gB0sUHGA/Bg9Z?= =?iso-8859-2?Q?AVusP78LGHYfgP+YGKjRAD/J+Pi8fSu1HujPy2aye8ZkIUKDAwjzZKpdzU?= =?iso-8859-2?Q?qj521+DVjhJo3fr4zi/EtkMNgEeqjkH/lbbmkRPYa6ZBSUue4SPAaCbdzh?= =?iso-8859-2?Q?cL4NYq15Jw+g5odXh79MPXQKNvdvaAGd17eDCo3TDsAjxYQn6BfcLDRNj0?= =?iso-8859-2?Q?fTkkX9x5ReDPrIHi3ffLRihrbjqzjRJXKV0tTK4NXphxOVNzXbAOH65X6A?= =?iso-8859-2?Q?5+IZJ/nyFzQAoQwUc0WMY34DudsOPh92cuhf7pKvVDsFY1N5+oCJOPQLtD?= =?iso-8859-2?Q?pZ3VB0OLD/Lk5uQyse9qG9bI4kXsWh3taulJFYsJz7aGsTDWK36G3D6b2j?= =?iso-8859-2?Q?zK0MgIL1qsTu+VzoRo9Vu6zfag1BZbzACAPxu11OZjBHOPZO3YF/Hd8Bqu?= =?iso-8859-2?Q?FeUdCpRssZJcB1eytMTkQXR82CcZcQEuzQmnFF7E8SjBrGnEVMRPPk8mDq?= =?iso-8859-2?Q?vfIrXYBBcfuLSV/9J08o+jAoYkW+Zmrt3JSy8UFYpaHxrV5dKjo6yhEcoD?= =?iso-8859-2?Q?on0lQDoVlE3dM6r6NsWl1dxLyJuQG2eSqZCnsGxLlqGZeKFg1P8PusuXak?= =?iso-8859-2?Q?K9SAdm5EBrz1K84PEdBVCo2otnNqMVh+dZ3IbIH6Hg6zox4ulgGbw=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AS8PR03MB8781.eurprd03.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230037)(1800799021)(366013)(376011)(38070700015);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-2?Q?mMe5MxrEhzYxr+yqvsGXcbbtlSRhltLEfxvFURwPRJNVwPAXgHwDkEkr+T?= =?iso-8859-2?Q?wqIA8mT41qWYW1uTn0FZL7jwKaPlNkduecksaJ1bv+IxjUeD/gcolrlFy6?= =?iso-8859-2?Q?Mdq5OOU5bIydwTSGyBxstlX6pm6ZwlhmXtPoQIl6AUik0ZOrkkif74o0n5?= =?iso-8859-2?Q?uJ+upX6qzYipVVy/Jlz96vErsu6UwOtAMX+ejgrwkDNyXLjs+fI+sorSkA?= =?iso-8859-2?Q?q/Jl5O78fSFYD6/4mrRwaotX7j12xSIMKC/wIzzHw+1cKDj4FYBn+96bGZ?= =?iso-8859-2?Q?T0noA5bxo8VXsJ1CHqkFY7/ZhhnuqEfO1C0Px0sF2pTa2vCQZNWPd8KS1B?= =?iso-8859-2?Q?v7UgyC66GYTyi82JG7UZG3LK2n+ggL9MpKdZ/+QGOb+j8zd4/bscYHdkbx?= =?iso-8859-2?Q?bypWAUMtk+E3leRPBtLAszNu+Rt3rDhk/ao90xJXqCuwCIGPcno/vHgg0i?= =?iso-8859-2?Q?s8Q3JaGQVuC5zi+Ao1xTXF65y4eD3oGFcq70JlWzhv5j5xreVuDjG97sN7?= =?iso-8859-2?Q?QaI0/7p1OdFLT0GS1i2daOp3AxW1y241CTa3cGq42U6nuVO/sMnTAJoFd2?= =?iso-8859-2?Q?3h7ZO3qVKGH29iI2VIsBU/eK05li80qBCunPb0P11LGM30TOpbo0Mok53g?= =?iso-8859-2?Q?MaN2n61uYf6DiTpF/TN8PVaguDutE3vnbCH1cHnrlQiXoqFd+3ALrSgkIJ?= =?iso-8859-2?Q?q0hegGrVsOGEeEC1DFvwb3sKBYs3O9NTwrY1dY+dQCFdjDv/Tu4o6+sY9w?= =?iso-8859-2?Q?NQw6lQ6q8QNB4hRW8oKUKQBCn16pjQipu6jtHjUABxUqX/ElmMEv8V/wJ7?= =?iso-8859-2?Q?xqEjRmL5svoFCeZTtvGDYqzWmcHn1QL9N+7JIGa2/0DZ2Zgft3L/dJwS4Y?= =?iso-8859-2?Q?Aa1+4MdEAVl3UrnoeK9/uub/S0OS42+/QtepRsuB8C85BZsz6k67a2ecfV?= =?iso-8859-2?Q?IAaMTZfPYLV5u5Ww55BRNUSXnTITcLIG2c8dmysGQHJSxmHiPKkBHvtF1e?= =?iso-8859-2?Q?WcPekv4UBgZO4c+n3ApTiWzRgGWMnT3nJJ0jafcpkfzD2TYZxO81/U8BO3?= =?iso-8859-2?Q?5D1I9K0hMtAsJZerpsO4nNKY2KTUW6XndHUxCh7druvcIzZhVz55G3rrjv?= =?iso-8859-2?Q?7bnxc+40P2X3Ht3EPwF2on6+Pcya+1VM1Jg5J/iWpWO1/5txhq6N+WsfSo?= =?iso-8859-2?Q?1XmxkEs9xyGsel6uYIvX1LykiUvwWOwn/RubcZ/DHCm1pNiVtjdiacSVjh?= =?iso-8859-2?Q?V4jPtxdjATryiRrYtMWQVlNgChSi6iJV6jhAeK8S4cPnz4zd3QTDMRzjUB?= =?iso-8859-2?Q?EllrkiTnUuLU0/Y4s/4tmh8U9y0mgT0VzBAXrLJMFz94Ek0TQOermpSFaM?= =?iso-8859-2?Q?0IqkDB4/JsC2TPfqNCHcjLLgrVXQGsUS/e1SLTluG39FYM47YSShOhgkfv?= =?iso-8859-2?Q?dciNfRUf529OnBWXjNkHpqDDu8ATFJiAbTWWpRZyRCkpsCRRHdPgeHPDyd?= =?iso-8859-2?Q?SYoQOkHG6JpaacaUkjiWxuqx6BoO57MhKx+YTyk+cCNelCTdfZxaimAAGA?= =?iso-8859-2?Q?7DmRGnrDz3FO83Q/8sVwSqz/I7Nc0P7AljzP5kJU3B7eprELBGLmpTuFDw?= =?iso-8859-2?Q?JENrA3GtMMKxRGOsYkB3UJlca2z9t46Er2?= Content-Type: multipart/alternative; boundary="_000_AS8PR03MB8781D94903B5866E14BB81DD91C82AS8PR03MB8781eurp_" MIME-Version: 1.0 X-OriginatorOrg: spcss.cz X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AS8PR03MB8781.eurprd03.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: c2e6ea41-a0f2-4c6d-e7a3-08dc90e69c35 X-MS-Exchange-CrossTenant-originalarrivaltime: 20 Jun 2024 05:05:31.7388 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 8ef2ef64-61e6-4033-9f7f-48ccd5d03c90 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: S1FwzMDT+EQo8CjjH/1TfKBAUSqn8Y0sIG5WJQAxbCmg337VQMXlyhR0odyM5k/KIaI85IB7NEh6vDJhL3Gmbg== X-MS-Exchange-Transport-CrossTenantHeadersStamped: GV2PR03MB9500 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_AS8PR03MB8781D94903B5866E14BB81DD91C82AS8PR03MB8781eurp_ Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable 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 =3D 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 =F8=E1dka) 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=3D# 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=3D# It seems python was not upgraded when I upgrade PostgreSQL. Is possible upg= rade the python to actual version 3.9.x installed on RedHat 8.5 ? Thanks Michal TLP:AMBER --_000_AS8PR03MB8781D94903B5866E14BB81DD91C82AS8PR03MB8781eurp_ Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable

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 =3D 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 =F8=E1dka)

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=3D# 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=3D#

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

Thanks 
Michal

TLP:AMBER

--_000_AS8PR03MB8781D94903B5866E14BB81DD91C82AS8PR03MB8781eurp_--