4 files changed, 95 insertions, 0 deletions
diff --git a/databases/postgresql12-plpython/DESCR b/databases/postgresql12-plpython/DESCR
new file mode 100644
index 00000000000..142bb15309d
--- /dev/null
+++ b/databases/postgresql12-plpython/DESCR
@@ -0,0 +1,9 @@
+PL/Python allows you to write functions in the Python programming
+language that may be used in SQL queries as if they were built into
+Postgres.  The PL/Python intepreter is a full Python interpreter.
+
+PL/Python is currently only available as an "untrusted" language
+(meaning it does not offer any way of restricting what users can do
+in it).  It has therefore been named "plpythonu".  The trusted variant
+plpython may become available again in future, if a new secure execution
+mechanism is developed in Python.
diff --git a/databases/postgresql12-plpython/MESSAGE b/databases/postgresql12-plpython/MESSAGE
new file mode 100644
index 00000000000..7fa2c470c24
--- /dev/null
+++ b/databases/postgresql12-plpython/MESSAGE
@@ -0,0 +1,17 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1 2019/10/07 19:21:49 adam Exp $
+
+Please see the PL/Python section of the PostgreSQL Programmer's Guide
+(databases/postgresql-docs) for information on programming with
+${PKGNAME}.
+
+Note that PL/Python is unrestricted language, meaning it does not
+offer any way of restricting what users can do in it.  Any DB user with
+access to PL/Python can run arbitrary Python code under privileges
+of the PostgreSQL server process.
+
+To enable PL/Python for database <dbname>, run following:
+
+createlang plpythonu <dbname>
+
+===========================================================================
diff --git a/databases/postgresql12-plpython/Makefile b/databases/postgresql12-plpython/Makefile
new file mode 100644
index 00000000000..e3ad182e2ed
--- /dev/null
+++ b/databases/postgresql12-plpython/Makefile
@@ -0,0 +1,18 @@
+# $NetBSD: Makefile,v 1.1 2019/10/07 19:21:49 adam Exp $
+
+PKGNAME=	${DISTNAME:C/-/12-plpython-/}
+COMMENT=	PL/Python procedural language for the PostgreSQL backend
+
+DEPENDS+=	postgresql12-server>=${PKGVERSION_NOREV}:../../databases/postgresql12-server
+
+.include "../../databases/postgresql12/Makefile.common"
+
+CONFIGURE_ARGS+=	--with-python
+CONFIGURE_ENV+=		PYTHON="${PYTHONBIN}"
+BUILD_MAKE_FLAGS=	PGXS=1
+
+BUILD_DIRS=		src/pl/plpython contrib/hstore_plpython
+
+.include "../../databases/postgresql12-client/buildlink3.mk"
+.include "../../lang/python/extension.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql12-plpython/PLIST b/databases/postgresql12-plpython/PLIST
new file mode 100644
index 00000000000..4871164e42c
--- /dev/null
+++ b/databases/postgresql12-plpython/PLIST
@@ -0,0 +1,51 @@
+@comment $NetBSD: PLIST,v 1.1 2019/10/07 19:21:49 adam Exp $
+include/postgresql/server/plpy_cursorobject.h
+include/postgresql/server/plpy_elog.h
+include/postgresql/server/plpy_exec.h
+include/postgresql/server/plpy_main.h
+include/postgresql/server/plpy_planobject.h
+include/postgresql/server/plpy_plpymodule.h
+include/postgresql/server/plpy_procedure.h
+include/postgresql/server/plpy_resultobject.h
+include/postgresql/server/plpy_spi.h
+include/postgresql/server/plpy_subxactobject.h
+include/postgresql/server/plpy_typeio.h
+include/postgresql/server/plpy_util.h
+include/postgresql/server/plpython.h
+${PLIST.llvm}lib/postgresql/bitcode/hstore_plpython3.index.bc
+${PLIST.llvm}lib/postgresql/bitcode/hstore_plpython3/hstore_plpython.bc
+${PLIST.py2x}lib/postgresql/hstore_plpython2.so
+${PLIST.py3x}lib/postgresql/hstore_plpython3.so
+lib/postgresql/pgxs/src/pl/plpython/regress-python3-mangle.mk
+${PLIST.py2x}lib/postgresql/plpython2.so
+${PLIST.py3x}lib/postgresql/plpython3.so
+share/locale/cs/LC_MESSAGES/plpython-12.mo
+share/locale/de/LC_MESSAGES/plpython-12.mo
+share/locale/es/LC_MESSAGES/plpython-12.mo
+share/locale/fr/LC_MESSAGES/plpython-12.mo
+share/locale/it/LC_MESSAGES/plpython-12.mo
+share/locale/ja/LC_MESSAGES/plpython-12.mo
+share/locale/ko/LC_MESSAGES/plpython-12.mo
+share/locale/pl/LC_MESSAGES/plpython-12.mo
+share/locale/pt_BR/LC_MESSAGES/plpython-12.mo
+share/locale/ru/LC_MESSAGES/plpython-12.mo
+share/locale/sv/LC_MESSAGES/plpython-12.mo
+share/locale/tr/LC_MESSAGES/plpython-12.mo
+share/locale/uk/LC_MESSAGES/plpython-12.mo
+share/locale/vi/LC_MESSAGES/plpython-12.mo
+share/locale/zh_CN/LC_MESSAGES/plpython-12.mo
+share/postgresql/extension/hstore_plpython2u--1.0.sql
+share/postgresql/extension/hstore_plpython2u.control
+share/postgresql/extension/hstore_plpython3u--1.0.sql
+share/postgresql/extension/hstore_plpython3u.control
+share/postgresql/extension/hstore_plpythonu--1.0.sql
+share/postgresql/extension/hstore_plpythonu.control
+${PLIST.py2x}share/postgresql/extension/plpython2u--1.0.sql
+${PLIST.py2x}share/postgresql/extension/plpython2u--unpackaged--1.0.sql
+${PLIST.py2x}share/postgresql/extension/plpython2u.control
+${PLIST.py3x}share/postgresql/extension/plpython3u--1.0.sql
+${PLIST.py3x}share/postgresql/extension/plpython3u--unpackaged--1.0.sql
+${PLIST.py3x}share/postgresql/extension/plpython3u.control
+${PLIST.py2x}share/postgresql/extension/plpythonu--1.0.sql
+${PLIST.py2x}share/postgresql/extension/plpythonu--unpackaged--1.0.sql
+${PLIST.py2x}share/postgresql/extension/plpythonu.control