diff options
author | adam <adam@pkgsrc.org> | 2013-09-10 15:32:32 +0000 |
---|---|---|
committer | adam <adam@pkgsrc.org> | 2013-09-10 15:32:32 +0000 |
commit | 109fdd9f83c4e1e0843e1431814119025c8b3f62 (patch) | |
tree | ef2c53e491faea05c5ea8ccb8ccdfd9b86064cde /databases/postgresql93-plpython | |
parent | f4227f726d2d82741a9d4592270c49194c691343 (diff) | |
download | pkgsrc-109fdd9f83c4e1e0843e1431814119025c8b3f62.tar.gz |
Major enhancements in PostgreSQL 9.3 include:
* Add materialized views
* Make simple views auto-updatable
* Add many features for the JSON data type, including operators and functions to extract elements from JSON values
* Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls
* Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables
* Add a Postgres foreign data wrapper to allow access to other Postgres servers
* Add support for event triggers
* Add optional ability to checksum data pages and report corruption
* Prevent non-key-field row updates from blocking foreign key checks
* Greatly reduce System V shared memory requirements
Diffstat (limited to 'databases/postgresql93-plpython')
-rw-r--r-- | databases/postgresql93-plpython/DESCR | 9 | ||||
-rw-r--r-- | databases/postgresql93-plpython/MESSAGE | 17 | ||||
-rw-r--r-- | databases/postgresql93-plpython/Makefile | 18 | ||||
-rw-r--r-- | databases/postgresql93-plpython/PLIST | 19 |
4 files changed, 63 insertions, 0 deletions
diff --git a/databases/postgresql93-plpython/DESCR b/databases/postgresql93-plpython/DESCR new file mode 100644 index 00000000000..142bb15309d --- /dev/null +++ b/databases/postgresql93-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/postgresql93-plpython/MESSAGE b/databases/postgresql93-plpython/MESSAGE new file mode 100644 index 00000000000..27f28a5d609 --- /dev/null +++ b/databases/postgresql93-plpython/MESSAGE @@ -0,0 +1,17 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1 2013/09/10 15:32:33 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/postgresql93-plpython/Makefile b/databases/postgresql93-plpython/Makefile new file mode 100644 index 00000000000..0a29840915a --- /dev/null +++ b/databases/postgresql93-plpython/Makefile @@ -0,0 +1,18 @@ +# $NetBSD: Makefile,v 1.1 2013/09/10 15:32:33 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/93-plpython-/} +COMMENT= PL/Python procedural language for the PostgreSQL backend + +DEPENDS+= postgresql93-server>=${PKGVERSION_NOREV}:../../databases/postgresql93-server + +.include "../../databases/postgresql93/Makefile.common" + +CONFIGURE_ARGS+= --with-python +CONFIGURE_ENV+= PYTHON="${PYTHONBIN}" +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= src/pl/plpython + +.include "../../databases/postgresql93-client/buildlink3.mk" +.include "../../lang/python/extension.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql93-plpython/PLIST b/databases/postgresql93-plpython/PLIST new file mode 100644 index 00000000000..06f34bd0455 --- /dev/null +++ b/databases/postgresql93-plpython/PLIST @@ -0,0 +1,19 @@ +@comment $NetBSD: PLIST,v 1.1 2013/09/10 15:32:33 adam Exp $ +lib/postgresql/plpython2.so +share/locale/cs/LC_MESSAGES/plpython-9.3.mo +share/locale/de/LC_MESSAGES/plpython-9.3.mo +share/locale/es/LC_MESSAGES/plpython-9.3.mo +share/locale/fr/LC_MESSAGES/plpython-9.3.mo +share/locale/it/LC_MESSAGES/plpython-9.3.mo +share/locale/ja/LC_MESSAGES/plpython-9.3.mo +share/locale/pl/LC_MESSAGES/plpython-9.3.mo +share/locale/pt_BR/LC_MESSAGES/plpython-9.3.mo +share/locale/ro/LC_MESSAGES/plpython-9.3.mo +share/locale/ru/LC_MESSAGES/plpython-9.3.mo +share/locale/zh_CN/LC_MESSAGES/plpython-9.3.mo +share/postgresql/extension/plpython2u--1.0.sql +share/postgresql/extension/plpython2u--unpackaged--1.0.sql +share/postgresql/extension/plpython2u.control +share/postgresql/extension/plpythonu--1.0.sql +share/postgresql/extension/plpythonu--unpackaged--1.0.sql +share/postgresql/extension/plpythonu.control |