pgsql: Prepare for Python "Limited API" in PL/Python

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Prepare for Python "Limited API" in PL/Python
Date: 2025-03-12 07:58:53
Message-ID: E1tsGzN-00244X-1f@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Prepare for Python "Limited API" in PL/Python

Using the Python Limited API would allow building PL/Python against
any Python 3.x version and using another Python 3.x version at run
time. This commit does not activate that, but it prepares the code to
only use APIs supported by the Limited API.

Implementation details:

- Convert static types to heap types
(https://docs.python.org/3/howto/isolating-extensions.html#heap-types)

- Replace PyRun_String() with component functions.

- Replace PyList_SET_ITEM() with PyList_SetItem().

This was previously committed as c47e8df815c and then reverted because
it wasn't working under Python older than 3.8. That has been fixed in
this version. There was a Python API change/bugfix between 3.7 and
3.8 that directly affects this patch. The relevant commit is
<https://github.com/python/cpython/commit/364f0b0f19c>. The
workarounds described there have been applied in this patch, and it
has been confirmed to work with Python 3.6 and 3.7.

Reviewed-by: Jakob Egger <jakob(at)eggerapps(dot)at>
Discussion: https://www.postgresql.org/message-id/flat/ee410de1-1e0b-4770-b125-eeefd4726a24(at)eisentraut(dot)org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/72a3d0462b9a7f6265267950668af0c0246e7c01

Modified Files
--------------
src/pl/plpython/plpy_cursorobject.c | 84 +++++++++++++++++++--------
src/pl/plpython/plpy_planobject.c | 70 +++++++++++++++-------
src/pl/plpython/plpy_procedure.c | 5 +-
src/pl/plpython/plpy_resultobject.c | 109 ++++++++++++++++++++++-------------
src/pl/plpython/plpy_subxactobject.c | 46 +++++++++------
src/pl/plpython/plpy_typeio.c | 6 +-
6 files changed, 213 insertions(+), 107 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2025-03-12 08:15:15 Re: pgsql: pg_logicalinspect: Fix possible crash when passing a directory p
Previous Message David Rowley 2025-03-12 06:38:50 Re: pgsql: pg_logicalinspect: Fix possible crash when passing a directory p