summaryrefslogtreecommitdiff
path: root/databases/postgresql91-plpython
diff options
context:
space:
mode:
authoradam <adam@pkgsrc.org>2011-09-15 08:27:38 +0000
committeradam <adam@pkgsrc.org>2011-09-15 08:27:38 +0000
commitbfd12bfb1edc31693ca2b3ac46752e60f3f5f362 (patch)
treee4278cd9abc25bd225f1dd7ef33d4023332332b6 /databases/postgresql91-plpython
parentd162e8d1617159d190abd1e6ec4d1fdca0c6bdb2 (diff)
downloadpkgsrc-bfd12bfb1edc31693ca2b3ac46752e60f3f5f362.tar.gz
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
Diffstat (limited to 'databases/postgresql91-plpython')
-rw-r--r--databases/postgresql91-plpython/DESCR9
-rw-r--r--databases/postgresql91-plpython/MESSAGE17
-rw-r--r--databases/postgresql91-plpython/Makefile20
-rw-r--r--databases/postgresql91-plpython/PLIST22
4 files changed, 68 insertions, 0 deletions
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 <dbname>, run following:
+
+createlang plpythonu <dbname>
+
+===========================================================================
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