postgresql11: added version 11.0

PostgreSQL 11 provides users with improvements to overall performance of the database system, with specific enhancements associated with very large databases and high computational workloads. Further, PostgreSQL 11 makes significant improvements to the table partitioning system, adds support for stored procedures capable of transaction management, improves query parallelism and adds parallelized data definition capabilities, and introduces just-in-time (JIT) compilation for accelerating the execution of expressions in queries.

4 files changed, 92 insertions, 0 deletions

diff --git a/databases/postgresql11-plpython/DESCR b/databases/postgresql11-plpython/DESCR
new file mode 100644
index 00000000000..142bb15309d
--- /dev/null
+++ b/databases/postgresql11-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/postgresql11-plpython/MESSAGE b/databases/postgresql11-plpython/MESSAGE
new file mode 100644
index 00000000000..5387440ad5e
--- /dev/null
+++ b/databases/postgresql11-plpython/MESSAGE
@@ -0,0 +1,17 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1 2018/10/23 16:02:52 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/postgresql11-plpython/Makefile b/databases/postgresql11-plpython/Makefile
new file mode 100644
index 00000000000..bc70f6593cb
--- /dev/null
+++ b/databases/postgresql11-plpython/Makefile
@@ -0,0 +1,18 @@
+# $NetBSD: Makefile,v 1.1 2018/10/23 16:02:52 adam Exp $
+
+PKGNAME=	${DISTNAME:C/-/11-plpython-/}
+COMMENT=	PL/Python procedural language for the PostgreSQL backend
+
+DEPENDS+=	postgresql11-server>=${PKGVERSION_NOREV}:../../databases/postgresql11-server
+
+.include "../../databases/postgresql11/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/postgresql11-client/buildlink3.mk"
+.include "../../lang/python/extension.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql11-plpython/PLIST b/databases/postgresql11-plpython/PLIST
new file mode 100644
index 00000000000..23a783ff9ed
--- /dev/null
+++ b/databases/postgresql11-plpython/PLIST
@@ -0,0 +1,48 @@
+@comment $NetBSD: PLIST,v 1.1 2018/10/23 16:02:52 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.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-11.mo
+share/locale/de/LC_MESSAGES/plpython-11.mo
+share/locale/es/LC_MESSAGES/plpython-11.mo
+share/locale/fr/LC_MESSAGES/plpython-11.mo
+share/locale/it/LC_MESSAGES/plpython-11.mo
+share/locale/ja/LC_MESSAGES/plpython-11.mo
+share/locale/ko/LC_MESSAGES/plpython-11.mo
+share/locale/pl/LC_MESSAGES/plpython-11.mo
+share/locale/pt_BR/LC_MESSAGES/plpython-11.mo
+share/locale/ru/LC_MESSAGES/plpython-11.mo
+share/locale/sv/LC_MESSAGES/plpython-11.mo
+share/locale/tr/LC_MESSAGES/plpython-11.mo
+share/locale/vi/LC_MESSAGES/plpython-11.mo
+share/locale/zh_CN/LC_MESSAGES/plpython-11.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