From 8c1a4dea5891c9da73268a450d284d7b4b324463 Mon Sep 17 00:00:00 2001 From: tnn Date: Thu, 25 Feb 2016 21:37:35 +0000 Subject: Add postgresql95 packages, converted from corresponding postgresql94 packages. postgresql95-upgrade is gone, the pg_upgrade tool is shipped with postgresql95-client now. Major enhancements in PostgreSQL 9.5 include: Allow INSERTs that would generate constraint conflicts to be turned into UPDATEs or ignored Add GROUP BY analysis features GROUPING SETS, CUBE and ROLLUP Add row-level security control Create mechanisms for tracking the progress of replication, including methods for identifying the origin of individual changes during logical replication Add Block Range Indexes (BRIN) Substantial performance improvements for sorting Substantial performance improvements for multi-CPU machines --- databases/postgresql95-plpython/DESCR | 9 +++++++++ databases/postgresql95-plpython/MESSAGE | 17 ++++++++++++++++ databases/postgresql95-plpython/Makefile | 18 +++++++++++++++++ databases/postgresql95-plpython/PLIST | 34 ++++++++++++++++++++++++++++++++ 4 files changed, 78 insertions(+) create mode 100644 databases/postgresql95-plpython/DESCR create mode 100644 databases/postgresql95-plpython/MESSAGE create mode 100644 databases/postgresql95-plpython/Makefile create mode 100644 databases/postgresql95-plpython/PLIST (limited to 'databases/postgresql95-plpython') diff --git a/databases/postgresql95-plpython/DESCR b/databases/postgresql95-plpython/DESCR new file mode 100644 index 00000000000..142bb15309d --- /dev/null +++ b/databases/postgresql95-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/postgresql95-plpython/MESSAGE b/databases/postgresql95-plpython/MESSAGE new file mode 100644 index 00000000000..d269e20a112 --- /dev/null +++ b/databases/postgresql95-plpython/MESSAGE @@ -0,0 +1,17 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1 2016/02/25 21:37:36 tnn 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 , run following: + +createlang plpythonu + +=========================================================================== diff --git a/databases/postgresql95-plpython/Makefile b/databases/postgresql95-plpython/Makefile new file mode 100644 index 00000000000..7fafb729dd6 --- /dev/null +++ b/databases/postgresql95-plpython/Makefile @@ -0,0 +1,18 @@ +# $NetBSD: Makefile,v 1.1 2016/02/25 21:37:36 tnn Exp $ + +PKGNAME= ${DISTNAME:C/-/95-plpython-/} +COMMENT= PL/Python procedural language for the PostgreSQL backend + +DEPENDS+= postgresql95-server>=${PKGVERSION_NOREV}:../../databases/postgresql95-server + +.include "../../databases/postgresql95/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/postgresql95-client/buildlink3.mk" +.include "../../lang/python/extension.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql95-plpython/PLIST b/databases/postgresql95-plpython/PLIST new file mode 100644 index 00000000000..f6be4ded2a4 --- /dev/null +++ b/databases/postgresql95-plpython/PLIST @@ -0,0 +1,34 @@ +@comment $NetBSD: PLIST,v 1.1 2016/02/25 21:37:36 tnn 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 +share/locale/cs/LC_MESSAGES/plpython-9.5.mo +share/locale/de/LC_MESSAGES/plpython-9.5.mo +share/locale/es/LC_MESSAGES/plpython-9.5.mo +share/locale/fr/LC_MESSAGES/plpython-9.5.mo +share/locale/it/LC_MESSAGES/plpython-9.5.mo +share/locale/ja/LC_MESSAGES/plpython-9.5.mo +share/locale/ko/LC_MESSAGES/plpython-9.5.mo +share/locale/pl/LC_MESSAGES/plpython-9.5.mo +share/locale/pt_BR/LC_MESSAGES/plpython-9.5.mo +share/locale/ru/LC_MESSAGES/plpython-9.5.mo +share/locale/zh_CN/LC_MESSAGES/plpython-9.5.mo +@comment as of 9.5.1 installation of these is not dependent on python version +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 -- cgit v1.2.3