diff options
author | adam <adam@pkgsrc.org> | 2008-03-04 12:41:36 +0000 |
---|---|---|
committer | adam <adam@pkgsrc.org> | 2008-03-04 12:41:36 +0000 |
commit | ccf532ab0c1146ff606fbd4932571528a2ab23c7 (patch) | |
tree | 6540ccfa35e3ead303ed87ff04bfa2687ae2215a /databases/postgresql83-plpython | |
parent | 2b46efe7394cdfebca5ce79ea141e9cd8fc62508 (diff) | |
download | pkgsrc-ccf532ab0c1146ff606fbd4932571528a2ab23c7.tar.gz |
PostgreSQL 8.3
With significant new functionality and performance enhancements, this
release represents a major leap forward for PostgreSQL. This was made
possible by a growing community that has dramatically accelerated the
pace of development. This release adds the following major features:
* Full text search is integrated into the core database system
* Support for the SQL/XML standard, including new operators and an
XML data type
* Enumerated data types (ENUM)
* Arrays of composite types
* Universally Unique Identifier (UUID) data type
* Add control over whether NULLs sort first or last
* Updatable cursors
* Server configuration parameters can now be set on a per-function
basis
* User-defined types can now have type modifiers
* Automatically re-plan cached queries when table definitions change
or statistics are updated
* Numerous improvements in logging and statistics collection
* Support Security Service Provider Interface (SSPI) for
authentication on Windows
* Support multiple concurrent autovacuum processes, and other
autovacuum improvements
* Allow the whole PostgreSQL distribution to be compiled with
Microsoft Visual C++
Diffstat (limited to 'databases/postgresql83-plpython')
-rw-r--r-- | databases/postgresql83-plpython/DESCR | 9 | ||||
-rw-r--r-- | databases/postgresql83-plpython/MESSAGE | 17 | ||||
-rw-r--r-- | databases/postgresql83-plpython/Makefile | 21 | ||||
-rw-r--r-- | databases/postgresql83-plpython/PLIST | 2 |
4 files changed, 49 insertions, 0 deletions
diff --git a/databases/postgresql83-plpython/DESCR b/databases/postgresql83-plpython/DESCR new file mode 100644 index 00000000000..142bb15309d --- /dev/null +++ b/databases/postgresql83-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/postgresql83-plpython/MESSAGE b/databases/postgresql83-plpython/MESSAGE new file mode 100644 index 00000000000..919b4735396 --- /dev/null +++ b/databases/postgresql83-plpython/MESSAGE @@ -0,0 +1,17 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1.1.1 2008/03/04 12:44:41 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/postgresql83-plpython/Makefile b/databases/postgresql83-plpython/Makefile new file mode 100644 index 00000000000..4db658788bd --- /dev/null +++ b/databases/postgresql83-plpython/Makefile @@ -0,0 +1,21 @@ +# $NetBSD: Makefile,v 1.1.1.1 2008/03/04 12:44:41 adam Exp $ + +PKGNAME= postgresql83-plpython-${BASE_VERS} +COMMENT= PL/Python procedural language for the PostgreSQL backend + +DEPENDS+= postgresql83-server>=${BASE_VERS}:../../databases/postgresql83-server + +.include "../../databases/postgresql83/Makefile.common" + +CONFIGURE_ARGS+= --with-python +CONFIGURE_ENV+= PYTHON="${PYTHONBIN}" + +BUILD_DIRS= src/pl/plpython + +USE_LIBTOOL= yes +PKG_LIBTOOL= ${PKG_SHLIBTOOL} + +.include "../../databases/postgresql83-client/buildlink3.mk" +.include "../../lang/python/extension.mk" + +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql83-plpython/PLIST b/databases/postgresql83-plpython/PLIST new file mode 100644 index 00000000000..2f323dc99c8 --- /dev/null +++ b/databases/postgresql83-plpython/PLIST @@ -0,0 +1,2 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2008/03/04 12:44:41 adam Exp $ +${PG_SUBPREFIX}lib/postgresql/plpython.la |