From bfd12bfb1edc31693ca2b3ac46752e60f3f5f362 Mon Sep 17 00:00:00 2001 From: adam Date: Thu, 15 Sep 2011 08:27:38 +0000 Subject: Version 9.1 delivers several features which users have been requesting for years, removing roadblocks to deploying new or ported applications on PostgreSQL. These include: * Synchronous Replication: enable high-availability with consistency across multiple servers * Per-Column Collations: support linguistically-correct sorting per database, table or column. * Unlogged Tables: greatly improves performance for ephemeral data Our community of contributors innovates with cutting-edge features. Version 9.1 includes several which are new to the database industry, such as: * K-Nearest-Neighbor Indexing: index on "distance" for faster location and text search queries * Serializable Snapshot Isolation: keeps concurrent transactions consistent without blocking, using "true serializability" * Writeable Common Table Expressions: execute complex multi-stage data updates in a single query * Security-Enhanced Postgres: deploy military-grade security and Mandatory Access Control --- databases/postgresql91-plpython/DESCR | 9 +++++++++ databases/postgresql91-plpython/MESSAGE | 17 +++++++++++++++++ databases/postgresql91-plpython/Makefile | 20 ++++++++++++++++++++ databases/postgresql91-plpython/PLIST | 22 ++++++++++++++++++++++ 4 files changed, 68 insertions(+) create mode 100644 databases/postgresql91-plpython/DESCR create mode 100644 databases/postgresql91-plpython/MESSAGE create mode 100644 databases/postgresql91-plpython/Makefile create mode 100644 databases/postgresql91-plpython/PLIST (limited to 'databases/postgresql91-plpython') diff --git a/databases/postgresql91-plpython/DESCR b/databases/postgresql91-plpython/DESCR new file mode 100644 index 00000000000..142bb15309d --- /dev/null +++ b/databases/postgresql91-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/postgresql91-plpython/MESSAGE b/databases/postgresql91-plpython/MESSAGE new file mode 100644 index 00000000000..e5d4494239f --- /dev/null +++ b/databases/postgresql91-plpython/MESSAGE @@ -0,0 +1,17 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1.1.1 2011/09/15 08:31:43 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 , run following: + +createlang plpythonu + +=========================================================================== diff --git a/databases/postgresql91-plpython/Makefile b/databases/postgresql91-plpython/Makefile new file mode 100644 index 00000000000..eb4f195ffdb --- /dev/null +++ b/databases/postgresql91-plpython/Makefile @@ -0,0 +1,20 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:31:43 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-plpython-/} +COMMENT= PL/Python procedural language for the PostgreSQL backend + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +CONFIGURE_ARGS+= --with-python +CONFIGURE_ENV+= PYTHON="${PYTHONBIN}" +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= src/pl/plpython + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../lang/python/extension.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-plpython/PLIST b/databases/postgresql91-plpython/PLIST new file mode 100644 index 00000000000..e3034a524f6 --- /dev/null +++ b/databases/postgresql91-plpython/PLIST @@ -0,0 +1,22 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:31:43 adam Exp $ +lib/postgresql/plpython2.so +share/locale/cs/LC_MESSAGES/plpython-9.1.mo +share/locale/de/LC_MESSAGES/plpython-9.1.mo +share/locale/es/LC_MESSAGES/plpython-9.1.mo +share/locale/fr/LC_MESSAGES/plpython-9.1.mo +share/locale/ja/LC_MESSAGES/plpython-9.1.mo +share/locale/pl/LC_MESSAGES/plpython-9.1.mo +share/locale/pt_BR/LC_MESSAGES/plpython-9.1.mo +share/locale/ro/LC_MESSAGES/plpython-9.1.mo +share/locale/tr/LC_MESSAGES/plpython-9.1.mo +share/locale/zh_CN/LC_MESSAGES/plpython-9.1.mo +share/locale/zh_TW/LC_MESSAGES/plpython-9.1.mo +share/postgresql/extension/plpython2u--1.0.sql +share/postgresql/extension/plpython2u--unpackaged--1.0.sql +share/postgresql/extension/plpython2u.control +share/postgresql/extension/plpython3u--1.0.sql +share/postgresql/extension/plpython3u--unpackaged--1.0.sql +share/postgresql/extension/plpython3u.control +share/postgresql/extension/plpythonu--1.0.sql +share/postgresql/extension/plpythonu--unpackaged--1.0.sql +share/postgresql/extension/plpythonu.control -- cgit v1.2.3