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++

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