Changes 8.2.0:

* Query language enhancements including "INSERT/UPDATE/DELETE
  RETURNING", multirow VALUES lists, and optional target-table alias
  in "UPDATE"/"DELETE"
* Index creation without blocking concurrent
  "INSERT"/"UPDATE"/"DELETE" operations
* Many query optimization improvements, including support for
  reordering outer joins
* Improved sorting performance with lower memory usage
* More efficient locking with better concurrency
* More efficient vacuuming
* Easier administration of warm standby servers
* New FILLFACTOR support for tables and indexes
* Monitoring, logging, and performance tuning additions
* More control over creating and dropping objects
* Table inheritance relationships can be defined for and removed from
  pre-existing tables
* "COPY TO" can copy the output of an arbitrary "SELECT" statement
* Array improvements, including nulls in arrays
* Aggregate-function improvements, including multiple-input
  aggregates and SQL:2003 statistical functions
* Many "contrib/" improvements

15 files changed, 160 insertions, 0 deletions

diff --git a/databases/postgresql82-plperl/DESCR b/databases/postgresql82-plperl/DESCR
new file mode 100644
index 00000000000..9057591c0ba
--- /dev/null
+++ b/databases/postgresql82-plperl/DESCR
@@ -0,0 +1,5 @@
+PL/Perl allows you to write functions in the Perl programming language
+that may be used in SQL queries as if they were built into Postgres.
+The PL/Perl intepreter is a full Perl interpreter.  However, certain
+operations have been disabled in order to maintain the security of the
+system.
diff --git a/databases/postgresql82-plperl/MESSAGE b/databases/postgresql82-plperl/MESSAGE
new file mode 100644
index 00000000000..8180a231764
--- /dev/null
+++ b/databases/postgresql82-plperl/MESSAGE
@@ -0,0 +1,7 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2006/12/09 16:15:06 adam Exp $
+
+Please see the PL/Perl section of the PostgreSQL Programmer's Guide
+(databases/postgresql-docs) for information on programming with
+${PKGNAME}.
+===========================================================================
diff --git a/databases/postgresql82-plperl/Makefile b/databases/postgresql82-plperl/Makefile
new file mode 100644
index 00000000000..2fbc738d43a
--- /dev/null
+++ b/databases/postgresql82-plperl/Makefile
@@ -0,0 +1,22 @@
+# $NetBSD: Makefile,v 1.1.1.1 2006/12/09 16:15:06 adam Exp $
+
+PKGNAME=	postgresql82-plperl-${BASE_VERS}
+COMMENT=	PL/Perl procedural language for the PostgreSQL backend
+
+DEPENDS+=	postgresql82-server>=${BASE_VERS}:../../databases/postgresql82-server
+
+.include "../../databases/postgresql82/Makefile.common"
+
+PERL5_CONFIGURE=	no
+CONFIGURE_ARGS+=	--with-perl
+
+BUILD_DIRS=		${WRKSRC}/src/pl/plperl
+MAKE_FILE=		GNUmakefile
+
+USE_LIBTOOL=		yes
+PKG_LIBTOOL=		${PKG_SHLIBTOOL}
+
+.include "../../databases/postgresql82-client/buildlink3.mk"
+.include "../../lang/perl5/module.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql82-plperl/PLIST b/databases/postgresql82-plperl/PLIST
new file mode 100644
index 00000000000..c6fc40664fe
--- /dev/null
+++ b/databases/postgresql82-plperl/PLIST
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2006/12/09 16:15:06 adam Exp $
+${PG_SUBPREFIX}lib/postgresql/plperl.la
diff --git a/databases/postgresql82-plpython/DESCR b/databases/postgresql82-plpython/DESCR
new file mode 100644
index 00000000000..142bb15309d
--- /dev/null
+++ b/databases/postgresql82-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/postgresql82-plpython/MESSAGE b/databases/postgresql82-plpython/MESSAGE
new file mode 100644
index 00000000000..452dd11607a
--- /dev/null
+++ b/databases/postgresql82-plpython/MESSAGE
@@ -0,0 +1,17 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2006/12/09 16:14:23 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/postgresql82-plpython/Makefile b/databases/postgresql82-plpython/Makefile
new file mode 100644
index 00000000000..9ce53c0a684
--- /dev/null
+++ b/databases/postgresql82-plpython/Makefile
@@ -0,0 +1,21 @@
+# $NetBSD: Makefile,v 1.1.1.1 2006/12/09 16:14:23 adam Exp $
+
+PKGNAME=	postgresql82-plpython-${BASE_VERS}
+COMMENT=	PL/Python procedural language for the PostgreSQL backend
+
+DEPENDS+=	postgresql82-server>=${BASE_VERS}:../../databases/postgresql82-server
+
+.include "../../databases/postgresql82/Makefile.common"
+
+CONFIGURE_ARGS+=	--with-python
+CONFIGURE_ENV+=		PYTHON="${PYTHONBIN}"
+
+BUILD_DIRS=		${WRKSRC}/src/pl/plpython
+
+USE_LIBTOOL=		yes
+PKG_LIBTOOL=		${PKG_SHLIBTOOL}
+
+.include "../../databases/postgresql82-client/buildlink3.mk"
+.include "../../lang/python/extension.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql82-plpython/PLIST b/databases/postgresql82-plpython/PLIST
new file mode 100644
index 00000000000..21fbc4c551d
--- /dev/null
+++ b/databases/postgresql82-plpython/PLIST
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2006/12/09 16:14:23 adam Exp $
+${PG_SUBPREFIX}lib/postgresql/plpython.la
diff --git a/databases/postgresql82-pltcl/DESCR b/databases/postgresql82-pltcl/DESCR
new file mode 100644
index 00000000000..e1aca2980b9
--- /dev/null
+++ b/databases/postgresql82-pltcl/DESCR
@@ -0,0 +1,4 @@
+PL/Tcl is a dynamic loadable extension for the PostgreSQL database system
+that enables the Tcl language to be used to create functions and
+trigger-procedures.  It offers most of the capabilities a function
+writer has in the C language.
diff --git a/databases/postgresql82-pltcl/MESSAGE b/databases/postgresql82-pltcl/MESSAGE
new file mode 100644
index 00000000000..ec394622bba
--- /dev/null
+++ b/databases/postgresql82-pltcl/MESSAGE
@@ -0,0 +1,7 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2006/12/09 16:14:46 adam Exp $
+
+Please see the PL/Tcl section of the PostgreSQL Programmer's Guide
+(databases/postgresql-docs) for information on programming with
+${PKGNAME}.
+===========================================================================
diff --git a/databases/postgresql82-pltcl/Makefile b/databases/postgresql82-pltcl/Makefile
new file mode 100644
index 00000000000..cfbce001264
--- /dev/null
+++ b/databases/postgresql82-pltcl/Makefile
@@ -0,0 +1,23 @@
+# $NetBSD: Makefile,v 1.1.1.1 2006/12/09 16:14:46 adam Exp $
+
+PKGNAME=	postgresql82-pltcl-${BASE_VERS}
+COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
+
+DEPENDS+=	postgresql82-server>=${BASE_VERS}:../../databases/postgresql82-server
+
+.include "../../databases/postgresql82/Makefile.common"
+
+CONFIGURE_ARGS+=	--with-tcl
+CONFIGURE_ARGS+=	--with-tclconfig="${BUILDLINK_PREFIX.tcl}/lib"
+CONFIGURE_ENV+=		TCLSH="${TCLSH}"
+TCLSH=			${BUILDLINK_PREFIX.tcl}/bin/tclsh
+
+BUILD_DIRS=		${WRKSRC}/src/pl/tcl
+
+USE_LIBTOOL=		yes
+PKG_LIBTOOL=		${PKG_SHLIBTOOL}
+
+.include "../../databases/postgresql82-client/buildlink3.mk"
+.include "../../lang/tcl/buildlink3.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql82-pltcl/PLIST b/databases/postgresql82-pltcl/PLIST
new file mode 100644
index 00000000000..85b8dceeae5
--- /dev/null
+++ b/databases/postgresql82-pltcl/PLIST
@@ -0,0 +1,6 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2006/12/09 16:14:46 adam Exp $
+${PG_SUBPREFIX}bin/pltcl_delmod
+${PG_SUBPREFIX}bin/pltcl_listmod
+${PG_SUBPREFIX}bin/pltcl_loadmod
+${PG_SUBPREFIX}lib/postgresql/pltcl.la
+${PG_SUBPREFIX}share/postgresql/unknown.pltcl
diff --git a/databases/postgresql82-tsearch2/DESCR b/databases/postgresql82-tsearch2/DESCR
new file mode 100644
index 00000000000..cceb66da784
--- /dev/null
+++ b/databases/postgresql82-tsearch2/DESCR
@@ -0,0 +1,6 @@
+The Tsearch2 contrib module contains an implementation of a new data
+type tsvector - a searchable data type with indexed access. In a
+nutshell, tsvector is a set of unique words along with their
+positional information in the document, organized in a special
+structure optimized for fast access and lookup. This data type can
+be used as backend for efficient full text search engines.
diff --git a/databases/postgresql82-tsearch2/Makefile b/databases/postgresql82-tsearch2/Makefile
new file mode 100644
index 00000000000..60361ad9f24
--- /dev/null
+++ b/databases/postgresql82-tsearch2/Makefile
@@ -0,0 +1,17 @@
+# $NetBSD: Makefile,v 1.1.1.1 2006/12/09 16:13:57 adam Exp $
+
+PKGNAME=	postgresql82-tsearch2-${BASE_VERS}
+COMMENT=	Tsearch2 contrib module for fulltext indexing in PostgreSQL
+
+DEPENDS+=	postgresql82-server>=${BASE_VERS}:../../databases/postgresql82-server
+
+.include "../../databases/postgresql82/Makefile.common"
+
+BUILD_DIRS=		contrib/tsearch2/snowball contrib/tsearch2
+
+USE_LIBTOOL=		yes
+PKG_LIBTOOL=		${PKG_SHLIBTOOL}
+
+.include "../../databases/postgresql82-client/buildlink3.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql82-tsearch2/PLIST b/databases/postgresql82-tsearch2/PLIST
new file mode 100644
index 00000000000..458ae47dab9
--- /dev/null
+++ b/databases/postgresql82-tsearch2/PLIST
@@ -0,0 +1,12 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2006/12/09 16:13:57 adam Exp $
+${PG_SUBPREFIX}lib/postgresql/libtsearch2.la
+${PG_SUBPREFIX}share/doc/postgresql/contrib/README.tsearch2
+${PG_SUBPREFIX}share/postgresql/contrib/english.stop
+${PG_SUBPREFIX}share/postgresql/contrib/russian.stop
+${PG_SUBPREFIX}share/postgresql/contrib/russian.stop.utf8
+${PG_SUBPREFIX}share/postgresql/contrib/thesaurus
+${PG_SUBPREFIX}share/postgresql/contrib/tsearch2.sql
+${PG_SUBPREFIX}share/postgresql/contrib/uninstall_tsearch2.sql
+@dirrm share/postgresql/contrib
+@dirrm share/doc/postgresql/contrib
+@dirrm lib/postgresql