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

3 files changed, 104 insertions, 0 deletions

diff --git a/databases/postgresql93-datatypes/DESCR b/databases/postgresql93-datatypes/DESCR
new file mode 100644
index 00000000000..0fd1fb2d6cd
--- /dev/null
+++ b/databases/postgresql93-datatypes/DESCR
@@ -0,0 +1,43 @@
+This package provides the following PostgreSQL modules:
+  - citext
+  - hstore
+  - intarray
+  - isn
+  - ltree
+  - lo
+  - uuid-ossp
+  - unaccent
+
+The "citext" module provides a case-insensitive character string type,
+citext. Essentially, it internally calls lower when comparing values.
+Otherwise, it behaves almost exactly like text.
+
+The "hstore" module implements the "hstore" data type for storing sets
+of key/value pairs within a single PostgreSQL value. This can be useful
+in various scenarios, such as rows with many attributes that are rarely
+examined, or semi-structured data. Keys and values are simply text strings.
+
+The "intarray" module provides a number of useful functions and operators
+for manipulating one-dimensional arrays of integers. There is also support
+for indexed searches using some of the operators.
+
+The "isn" module provides data types for the following international
+product numbering standards: EAN13, UPC, ISBN (books), ISMN (music),
+and ISSN (serials). Numbers are validated on input, and correctly
+hyphenated on output.
+
+The "ltree" module implements a data type ltree for representing
+labels of data stored in a hierarchical tree-like structure.
+Extensive facilities for searching through label trees are provided.
+
+The "lo" module provides support for managing Large Objects (also called
+LOs or BLOBs). This includes a data type "lo" and a trigger "lo_manage."
+
+The "uuid-ossp" module provides functions to generate universally unique
+identifiers (UUIDs) using one of several standard algorithms. There are
+also functions to produce certain special UUID constants.
+
+"unaccent" is a text search dictionary that removes accents (diacritic signs)
+from lexemes. It's a filtering dictionary, which means its output is always
+passed to the next dictionary (if any), unlike the normal behavior of
+dictionaries. This allows accent-insensitive processing for full text search.
diff --git a/databases/postgresql93-datatypes/Makefile b/databases/postgresql93-datatypes/Makefile
new file mode 100644
index 00000000000..23e8e0eda97
--- /dev/null
+++ b/databases/postgresql93-datatypes/Makefile
@@ -0,0 +1,26 @@
+# $NetBSD: Makefile,v 1.1 2013/09/10 15:32:32 adam Exp $
+
+PKGNAME=	${DISTNAME:C/-/93-datatypes-/}
+COMMENT=	PostgreSQL data types support modules
+
+DEPENDS+=	postgresql93-server>=${PKGVERSION_NOREV}:../../databases/postgresql93-server
+
+.include "../../databases/postgresql93/Makefile.common"
+
+CONFIGURE_ARGS+=	--with-ossp-uuid
+# because global pg_config.h is included, we have to define this
+CPPFLAGS+=		-DHAVE_UUID_H
+
+BUILD_DIRS+=		contrib/citext
+BUILD_DIRS+=		contrib/hstore
+BUILD_DIRS+=		contrib/intarray
+BUILD_DIRS+=		contrib/isn
+BUILD_DIRS+=		contrib/ltree
+BUILD_DIRS+=		contrib/lo
+BUILD_DIRS+=		contrib/uuid-ossp
+BUILD_DIRS+=		contrib/unaccent
+BUILD_MAKE_FLAGS=	PGXS=1
+
+.include "../../databases/postgresql93-client/buildlink3.mk"
+.include "../../devel/ossp-uuid/buildlink3.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql93-datatypes/PLIST b/databases/postgresql93-datatypes/PLIST
new file mode 100644
index 00000000000..d83c3ee7622
--- /dev/null
+++ b/databases/postgresql93-datatypes/PLIST
@@ -0,0 +1,35 @@
+@comment $NetBSD: PLIST,v 1.1 2013/09/10 15:32:32 adam Exp $
+lib/postgresql/_int.so
+lib/postgresql/citext.so
+lib/postgresql/hstore.so
+lib/postgresql/isn.so
+lib/postgresql/lo.so
+lib/postgresql/ltree.so
+lib/postgresql/unaccent.so
+lib/postgresql/uuid-ossp.so
+share/postgresql/extension/citext--1.0.sql
+share/postgresql/extension/citext--unpackaged--1.0.sql
+share/postgresql/extension/citext.control
+share/postgresql/extension/hstore--1.0--1.1.sql
+share/postgresql/extension/hstore--1.1.sql
+share/postgresql/extension/hstore--unpackaged--1.0.sql
+share/postgresql/extension/hstore.control
+share/postgresql/extension/intarray--1.0.sql
+share/postgresql/extension/intarray--unpackaged--1.0.sql
+share/postgresql/extension/intarray.control
+share/postgresql/extension/isn--1.0.sql
+share/postgresql/extension/isn--unpackaged--1.0.sql
+share/postgresql/extension/isn.control
+share/postgresql/extension/lo--1.0.sql
+share/postgresql/extension/lo--unpackaged--1.0.sql
+share/postgresql/extension/lo.control
+share/postgresql/extension/ltree--1.0.sql
+share/postgresql/extension/ltree--unpackaged--1.0.sql
+share/postgresql/extension/ltree.control
+share/postgresql/extension/unaccent--1.0.sql
+share/postgresql/extension/unaccent--unpackaged--1.0.sql
+share/postgresql/extension/unaccent.control
+share/postgresql/extension/uuid-ossp--1.0.sql
+share/postgresql/extension/uuid-ossp--unpackaged--1.0.sql
+share/postgresql/extension/uuid-ossp.control
+share/postgresql/tsearch_data/unaccent.rules