Many of the changes in PostgreSQL 8.4 are new or improved administration and

monitoring tools and commands. Each user has their own favorite features which
will make day-to-day work with PostgreSQL easier and more productive for them.
Among the most popular enhancements are:

* Parallel Database Restore, speeding up recovery from backup up to 8 times
* Per-Column Permissions, allowing more granular control of sensitive data
* Per-database Collation Support, making PostgreSQL more useful in
  multi-lingual environments
* In-place Upgrades through pg_migrator (beta), enabling upgrades from 8.3 to
  8.4 without extensive downtime
* New Query Monitoring Tools, giving administrators more insight into query
  activity
* Greatly Reduced VACUUM Overhead through the Visibility Map
* New Monitoring Tools for current queries, query load and deadlocks

Version 8.4 also makes data analysis easier through the advanced ANSI SQL2003
features of windowing functions, common table expressions and recursive queries.
Enhancements to stored procedures, such as default parameters and variadic
parameters, make database server programming simpler and more compact.
Of course, there are also performance improvements included in this version.

4 files changed, 48 insertions, 0 deletions

diff --git a/databases/postgresql84-pltcl/DESCR b/databases/postgresql84-pltcl/DESCR
new file mode 100644
index 00000000000..e1aca2980b9
--- /dev/null
+++ b/databases/postgresql84-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/postgresql84-pltcl/MESSAGE b/databases/postgresql84-pltcl/MESSAGE
new file mode 100644
index 00000000000..5867a2cb186
--- /dev/null
+++ b/databases/postgresql84-pltcl/MESSAGE
@@ -0,0 +1,7 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2009/07/29 06:30:56 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/postgresql84-pltcl/Makefile b/databases/postgresql84-pltcl/Makefile
new file mode 100644
index 00000000000..ba6dd0a6c65
--- /dev/null
+++ b/databases/postgresql84-pltcl/Makefile
@@ -0,0 +1,25 @@
+# $NetBSD: Makefile,v 1.1.1.1 2009/07/29 06:30:56 adam Exp $
+
+PKGNAME=	postgresql84-pltcl-${BASE_VERS}
+COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
+
+PKG_DESTDIR_SUPPORT=	user-destdir
+
+DEPENDS+=	postgresql84-server>=${BASE_VERS}:../../databases/postgresql84-server
+
+.include "../../databases/postgresql84/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=		src/pl/tcl
+
+USE_LIBTOOL=		yes
+PKG_LIBTOOL=		${PKG_SHLIBTOOL}
+
+.include "../../databases/postgresql84-client/buildlink3.mk"
+.include "../../lang/tcl/buildlink3.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql84-pltcl/PLIST b/databases/postgresql84-pltcl/PLIST
new file mode 100644
index 00000000000..44cabb93b1c
--- /dev/null
+++ b/databases/postgresql84-pltcl/PLIST
@@ -0,0 +1,12 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2009/07/29 06:30:56 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
+${PG_SUBPREFIX}share/locale/de/LC_MESSAGES/pltcl0-8.4.mo
+${PG_SUBPREFIX}share/locale/es/LC_MESSAGES/pltcl0-8.4.mo
+${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/pltcl0-8.4.mo
+${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/pltcl0-8.4.mo
+${PG_SUBPREFIX}share/locale/pt_BR/LC_MESSAGES/pltcl0-8.4.mo
+${PG_SUBPREFIX}share/locale/tr/LC_MESSAGES/pltcl0-8.4.mo