The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.1, 9.5.5, 9.4.10, 9.3.15, 9.2.19, and 9.1.24. This is also the last update for the PostgreSQL 9.1 series as it is now end-of-life. This release fixes two issues that can cause data corruption, which are described in more detail below. It also patches a number of other bugs reported over the last three months. The project urges users to apply this update at the next possible downtime.

4 files changed, 78 insertions, 0 deletions

diff --git a/databases/postgresql96-plpython/DESCR b/databases/postgresql96-plpython/DESCR
new file mode 100644
index 00000000000..142bb15309d
--- /dev/null
+++ b/databases/postgresql96-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/postgresql96-plpython/MESSAGE b/databases/postgresql96-plpython/MESSAGE
new file mode 100644
index 00000000000..7623c53d6db
--- /dev/null
+++ b/databases/postgresql96-plpython/MESSAGE
@@ -0,0 +1,17 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1 2016/10/29 19:41:55 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/postgresql96-plpython/Makefile b/databases/postgresql96-plpython/Makefile
new file mode 100644
index 00000000000..e0ce861b3ea
--- /dev/null
+++ b/databases/postgresql96-plpython/Makefile
@@ -0,0 +1,18 @@
+# $NetBSD: Makefile,v 1.1 2016/10/29 19:41:55 adam Exp $
+
+PKGNAME=	${DISTNAME:C/-/96-plpython-/}
+COMMENT=	PL/Python procedural language for the PostgreSQL backend
+
+DEPENDS+=	postgresql96-server>=${PKGVERSION_NOREV}:../../databases/postgresql96-server
+
+.include "../../databases/postgresql96/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/postgresql96-client/buildlink3.mk"
+.include "../../lang/python/extension.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql96-plpython/PLIST b/databases/postgresql96-plpython/PLIST
new file mode 100644
index 00000000000..4b6dd631f04
--- /dev/null
+++ b/databases/postgresql96-plpython/PLIST
@@ -0,0 +1,34 @@
+@comment $NetBSD: PLIST,v 1.1 2016/10/29 19:41:55 adam Exp $
+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
+${PLIST.py2x}lib/postgresql/plpython2.so
+${PLIST.py3x}lib/postgresql/plpython3.so
+@comment as of 9.5.1 installation of these is not dependent on python version
+share/locale/cs/LC_MESSAGES/plpython-9.6.mo
+share/locale/de/LC_MESSAGES/plpython-9.6.mo
+share/locale/es/LC_MESSAGES/plpython-9.6.mo
+share/locale/fr/LC_MESSAGES/plpython-9.6.mo
+share/locale/it/LC_MESSAGES/plpython-9.6.mo
+share/locale/ja/LC_MESSAGES/plpython-9.6.mo
+share/locale/ko/LC_MESSAGES/plpython-9.6.mo
+share/locale/pl/LC_MESSAGES/plpython-9.6.mo
+share/locale/pt_BR/LC_MESSAGES/plpython-9.6.mo
+share/locale/ru/LC_MESSAGES/plpython-9.6.mo
+share/locale/zh_CN/LC_MESSAGES/plpython-9.6.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