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

4 files changed, 56 insertions, 0 deletions

diff --git a/databases/postgresql93-pltcl/DESCR b/databases/postgresql93-pltcl/DESCR
new file mode 100644
index 00000000000..e1aca2980b9
--- /dev/null
+++ b/databases/postgresql93-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/postgresql93-pltcl/MESSAGE b/databases/postgresql93-pltcl/MESSAGE
new file mode 100644
index 00000000000..4efff3dd22c
--- /dev/null
+++ b/databases/postgresql93-pltcl/MESSAGE
@@ -0,0 +1,7 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1 2013/09/10 15:32:33 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/postgresql93-pltcl/Makefile b/databases/postgresql93-pltcl/Makefile
new file mode 100644
index 00000000000..0d48f4bfb53
--- /dev/null
+++ b/databases/postgresql93-pltcl/Makefile
@@ -0,0 +1,20 @@
+# $NetBSD: Makefile,v 1.1 2013/09/10 15:32:33 adam Exp $
+
+PKGNAME=	${DISTNAME:C/-/93-pltcl-/}
+COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
+
+DEPENDS+=	postgresql93-server>=${PKGVERSION_NOREV}:../../databases/postgresql93-server
+
+.include "../../databases/postgresql93/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_MAKE_FLAGS=	PGXS=1
+
+BUILD_DIRS=		src/pl/tcl
+
+.include "../../databases/postgresql93-client/buildlink3.mk"
+.include "../../lang/tcl/buildlink3.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql93-pltcl/PLIST b/databases/postgresql93-pltcl/PLIST
new file mode 100644
index 00000000000..e16d35d80d5
--- /dev/null
+++ b/databases/postgresql93-pltcl/PLIST
@@ -0,0 +1,25 @@
+@comment $NetBSD: PLIST,v 1.1 2013/09/10 15:32:33 adam Exp $
+bin/pltcl_delmod
+bin/pltcl_listmod
+bin/pltcl_loadmod
+lib/postgresql/pltcl.so
+share/locale/cs/LC_MESSAGES/pltcl-9.3.mo
+share/locale/de/LC_MESSAGES/pltcl-9.3.mo
+share/locale/es/LC_MESSAGES/pltcl-9.3.mo
+share/locale/fr/LC_MESSAGES/pltcl-9.3.mo
+share/locale/it/LC_MESSAGES/pltcl-9.3.mo
+share/locale/ja/LC_MESSAGES/pltcl-9.3.mo
+share/locale/pl/LC_MESSAGES/pltcl-9.3.mo
+share/locale/pt_BR/LC_MESSAGES/pltcl-9.3.mo
+share/locale/ro/LC_MESSAGES/pltcl-9.3.mo
+share/locale/ru/LC_MESSAGES/pltcl-9.3.mo
+share/locale/tr/LC_MESSAGES/pltcl-9.3.mo
+share/locale/zh_CN/LC_MESSAGES/pltcl-9.3.mo
+share/locale/zh_TW/LC_MESSAGES/pltcl-9.3.mo
+share/postgresql/extension/pltcl--1.0.sql
+share/postgresql/extension/pltcl--unpackaged--1.0.sql
+share/postgresql/extension/pltcl.control
+share/postgresql/extension/pltclu--1.0.sql
+share/postgresql/extension/pltclu--unpackaged--1.0.sql
+share/postgresql/extension/pltclu.control
+share/postgresql/unknown.pltcl